mysql的文档指出:
ALTER TABLE, BEGIN, CREATE INDEX ,
DROP DATABASE , DROP INDEX, DROP TABLE ,
LOAD MASTER DATA , LOCK TABLES, RENAME TABLE,
SET AUTOCOMMIT=1, START TRANSACTION, TRUNCATE ,
这些操作,implicitly end a transaction。
ALTER TABLE, BEGIN, CREATE INDEX ,
DROP DATABASE , DROP INDEX, DROP TABLE ,
LOAD MASTER DATA , LOCK TABLES, RENAME TABLE,
SET AUTOCOMMIT=1, START TRANSACTION, TRUNCATE ,
这些操作,implicitly end a transaction。
ALTER TABLE
BEGIN
CREATE INDEX
DROP DATABASE
DROP TABLE
RENAME TABLE
TRUNCATE
的最全了http://www.mysql.com/doc/en/COMMIT.html