Hello,
I'm trying to create a single transaction for modifying multiple tables with a single SQL call, however, SQL tells me that I have an invalid query:
START TRANSACTION;
DELETE FROM a WHERE id=6523;
UPDATE table_relationships SET rel_asset_id=6524 WHERE rel_asset_id=6523;
DELETE FROM b WHERE rel_asset_id=6523;
DELETE FROM c WHERE rel_asset_id=6523;
DELETE FROM d WHERE rel_asset_id=6523;
DELETE FROM e WHERE rel_asset_id=6523;
DELETE FROM f WHERE rel_asset_id=6523;
DELETE FROM g WHERE rel_asset_id=6523;
DELETE FROM h WHERE rel_asset_id=6523;
DELETE FROM i WHERE rel_asset_id=6523;
UPDATE assets SET available=1 WHERE id=6524;
DELETE FROM pending WHERE id=4;
COMMIT;
I can execute each statement at a time, however when I try to put it into a transaction, or string them together with UNIONS, trouble ensues. Any ideas? Thanks!
