ROLLBACK

http://bbs.chinaunix.net/forum/viewtopic.php?t=609866&show_type=

有几种情况是无法rollback的：
ALTER TABLE

BEGIN

CREATE INDEX

CREATE TABLE

CREATE DATABASE

DROP DATABASE

DROP INDEX

DROP TABLE

LOAD MASTER DATA

LOCK TABLES

RENAME TABLE

SET AUTOCOMMIT=1

START TRANSACTION

TRUNCATE TABLE

UNLOCK TABLES

--------------------------------------------

BEGIN;
INSERT INTO TEMP(name) VALUES('test');
ROLLBACK;

原文转自：http://www.ltesting.net