note 22384 added to ref.mysql

From: 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

« previous php.notes (#31912) next »