Page 1 of 1

Transactions

Posted: Sat Jun 28, 2008 6:31 am
by tagomago
I need to use transactions to avoid synchronization problems when modifying my database. As part of my transaction procedure I have created some MySQL functions. These work fine from the MySQL command line but in PHP I cannot turn off auto commit and change the delimiter. This makes entering multi-line procs extremely difficult. Can anyone help?

Re: Transactions

Posted: Sat Jun 28, 2008 10:21 pm
by Ollie Saunders
there's a special function for multi line commands in mysqli but not mysql. I believe auto commit isn't an issue as long as you send a 'BEGIN' query before hand.