Luuk Jansen schrieb:
I have a quick newbee question:
Is is possible to update in multiple tables at the same time.
I am working with PHP scripts and will use the following example to
explain what I want to do:
I have a generic_user tables, which forms a INNER JOIN with the
logon_user table (with a join using id).
generic_user:
- id
- name
- passowrd
logon_user:
- id
- last_logon
- nickname
As I load all the fields at once in an array, and want to update the
same, so just something like
"UPDATE generic_user INNER JOIN logon_user USING (id) SET name='test',
nickname='test2' WHERE id = 1";
Is there anybody who can explain how to do this?
You either update both tables in subsequent update statements
(in one exec call or inside your transaction)
or create an updateable view.
(Just like aregular view and then add a rule for update - maybe
using a call to a stored function)
or just use the stored function directly.
HTH
Tino
