Transactions
Moderator: General Moderators
Transactions
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?
- Ollie Saunders
- DevNet Master
- Posts: 3179
- Joined: Tue May 24, 2005 6:01 pm
- Location: UK
Re: Transactions
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.