创建表:
CREATE TABLE ashui(aid INT AUTO_INCREMENT PRIMARY KEY,aname VARCHAR(20));
设置回滚点:START TRANSACTION;
给表插入数据:INSERT INTO ashui(aname)VALUE(‘sdag‘);
回滚事物:ROLLBACK;
事物的回滚
原文:http://www.cnblogs.com/chenrenshui/p/6593503.html