note 22384 added to ref.mysql
| From: | php-general at lists dot php dot net | Date: | Sun, 16 Jun 2002 04:38:18 +0000 |
| Subject: | note 22384 added to ref.mysql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-31912@lists.php.net to get a copy of this message | ||
Regarding transactions, you must use a recent MySQL version which supports InnoDB tables. you should
read the mysql manual (the part about Innodb tables, section 7.5) and configure your server to use
them.
Some reading about how it works:
http://php.weblogs.com/discuss/msgReader$1446?mode=topic
(Click where it says Part2, I can't put the direct URL here because it is too long)
Then in PHP you use commands like:
mysql_query("BEGIN");
mysql_query("COMMIT");
mysql_query("ROLLBACK");
You must make sure that you convert your existing tables to innodb or create new ones: CREATE TABLE
(...) type=innodb;
--
http://www.php.net/manual/en/ref.mysql.php
http://master.php.net/manage/user-notes.php?action=edit+22384
http://master.php.net/manage/user-notes.php?action=delete+22384
http://master.php.net/manage/user-notes.php?action=reject+22384