Transactions
Posted: Tue Nov 03, 2009 2:20 pm
If I'm not mistaken, InnoDB supports transactions, right? Though, how would changes to MyISAM tables intermixed with changes to InnoDB tables in a single transaction be handled through Doctrine?
For example, suppose we have two tables:
BANK1_CLIENTS (InnoDB)
id
balance
BANK2_CLIENTS (MyISAM)
id
balance
BEGIN -- start transaction
UPDATE bank1_clients SET balance = balance - 400 WHERE id=4
UPDATE bank2_clients SET balance = balance + 400 WHERE id=12
ROLLBACK
What would happen? If it'd just break, are there any ways around this?
For example, suppose we have two tables:
BANK1_CLIENTS (InnoDB)
id
balance
BANK2_CLIENTS (MyISAM)
id
balance
BEGIN -- start transaction
UPDATE bank1_clients SET balance = balance - 400 WHERE id=4
UPDATE bank2_clients SET balance = balance + 400 WHERE id=12
ROLLBACK
What would happen? If it'd just break, are there any ways around this?