Example of using "transaction" to operate MySQL using PHP

<? PHP
Mysql_query ("set autocommit = 0"); // set to not automatically submit, because MySQL runs immediately by default.
Mysql_query ("begin"); // start transaction Definition
If (! Mysql_query ("insert into table values ('1', '2 ')")){
Mysql_query ("roolback"); // determines whether to roll back When execution fails.
}
If (! Mysql_query ("insert into Table1 values ('2', '3 ')")){
Mysql_query ("roolback"); // determines whether the execution fails to be rolled back.
}
Mysql_query ("commit"); // executes the transaction
?>

 

MySQL versions earlier than MySQL 4.1.0 do not support "Transactions", that is, MySQL 4.1.0 only supports limited.