mysql 没有回滚

Question

[code="java"]

DROP PROCEDURE IF EXISTS initYTData;

CREATE PROCEDURE initYTData()
BEGIN
START TRANSACTION;
BEGIN
INSERT INTO test values (1 , 'test1');
INSERT INTO test values ('2sss','test2');
INSERT INTO test values ('3','test2');
COMMIT ;
END;
END;

CALL initYTData;
[/code]

或者
[code="java"]

DROP PROCEDURE IF EXISTS initYTData;

CREATE PROCEDURE initYTData()
BEGIN
START TRANSACTION;
INSERT INTO test values (1 , 'test1');
INSERT INTO test values ('2sss','test2');
INSERT INTO test values ('3','test2');
COMMIT ;
END;

CALL initYTData;
[/code]
都没有回滚、插入了第一条数据

Answer 1

查看下表的引擎是不是支持事务。InnoDB才支持事务，要是MyISAM就不支持了