Re: Inserting data to two tables

[Peter Brawley]

> Can I add to the SQL statement a condition that if one of the above "insert" fails to call Rollback?

As Phillip says, in its simplest form Rollback is all-or-none, but if you declare a SAVEPOINT, you can rollback to that defined line, see https://dev.mysql.com/doc/refman/5.7/en/savepoint.html.

You may also need to code actions on specific errors, see Declare Handler and Get Diagnostics in the manual.

If the first insert succeeds, a second insert can apply last_insert_id() to the foreign key column of the child table.



Edited 1 time(s). Last edit at 12/13/2017 12:52PM by Peter Brawley.