一直在用的一个框架,操作mysql,发现事务不起作用,调试许久,问了群里的一些朋友。终于发现,mysql用的Myisam引擎,原来此引擎不支持事务。
[img]http://dl.iteye.com/upload/attachment/0074/1113/3310b733-552b-395d-86d3-e6573bc8afd6.jpg[/img]
[img]http://dl.iteye.com/upload/attachment/0074/1115/fa3bbcfc-2cfd-3d25-b34c-5a8bb7edff4d.jpg[/img]
[img]http://dl.iteye.com/upload/attachment/0074/1117/196212fa-8521-3500-980b-f5b009da676e.jpg[/img]
[img]http://dl.iteye.com/upload/attachment/0074/1113/3310b733-552b-395d-86d3-e6573bc8afd6.jpg[/img]
show variables like '%storage_engine%';
show engines
[img]http://dl.iteye.com/upload/attachment/0074/1115/fa3bbcfc-2cfd-3d25-b34c-5a8bb7edff4d.jpg[/img]
[img]http://dl.iteye.com/upload/attachment/0074/1117/196212fa-8521-3500-980b-f5b009da676e.jpg[/img]