update

[Anon]

is it possible to update 2 tables simultaneously?

[zhabala]

No, it is impossible to update two tables with one SQL statement. You have to use transactionts to be sure that both updates are performed or in case of any error both are not performed.

Zdenek

[Anon]

hello Zdenek

well, is that possible to insert the records into two tables at a time?

[Anon]

No, it is impossible to insert into two tables with one SQL statement. You have to use transactionts to be sure that both inserts are performed or in case of any error both are not performed.

Just in case

No, it is impossible to delete from two tables with one SQL statement. You have to use transactionts to be sure that both deletes are performed or in case of any error both are not performed.

[zhabala]

Cool Lars, professional answer :o))