MySQL事务 - 查询更改数据库而不提交？

Question

I am trying to execute a series of different queries. Simply put, I need them all to execute successfully, or I need to have none of them execute.

At the moment, I do

mysql_query("SET autocommit=0;");
mysql_query("BEGIN;");
mysql_query("QUERY A");
if(mysql_error()){
    mysql_query("rollback;");
    die();
}
mysql_query("QUERY B");
if(mysql_error()){
    mysql_query("rollback;");
    die();
}else{
    mysql_query("commit;");
 }

The problem is that if I force query B to fail, I can still see the results of query A when looking at the database in phpmyadmin. Surely the query result should not be added to the database?

Answer 1

The problem is that you are using MyISAM.
As is evident by the output of SHOW ENGINES.

MyISAM does not support transactions, nor does it support foreign key constraints.
You'll need to upgrade your MySQL version to one which supports InnoDB.
This will solve your issue.

I'm guessing your ISP is not helping you, maybe customer support can assist.