Re: Updating in multiple tables

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