Insert-Update-Delete in multiple Tables

[Anon]

This has been up to discussion before but I have never seen any satisfying answer.

I use MySQL, and it works just fine.

The problem is that I have a huge amount of tables and often I Insert new rows in 4-5 tables and to make the connection in these is tiresome. Using a SELECT with LAST_INSERT_ID() I can collect the id but I find this method tiresome. The same occurs when I want to update and delete related rows in multiple tables.

Is there realy no better way to handle this? jumping in and out from MySQL seems a bit overhead.

Have anyone found a better and smother way to fix this?

[[deleted]]

"Is there realy no better way to handle this? jumping in and out from MySQL seems a bit overhead."

No there is no other way in mysql.

SQL simply does not do that, for semi-obious reasons like consistency.

[Anon]

I suspected that there were no way to do this.

I think this problem wouldn't occur in Object oriented databases.