创建表:
CREATE TABLE ashui(
aid INT AUTO_INCREMENT PRIMARY KEY,
aname VARCHAR(20)
);
设置回滚点:START TRANSACTION;
给表插入数据:INSERT INTO ashui(aname)VALUE('sdag');
回滚事物:ROLLBACK;
创建表:
CREATE TABLE ashui(
aid INT AUTO_INCREMENT PRIMARY KEY,
aname VARCHAR(20)
);
设置回滚点:START TRANSACTION;
给表插入数据:INSERT INTO ashui(aname)VALUE('sdag');
回滚事物:ROLLBACK;