Transactions

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
tagomago
Forum Newbie
Posts: 1
Joined: Sat Jun 28, 2008 6:27 am

Transactions

Post 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?
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Re: Transactions

Post 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.
Post Reply