1) set autocommit=0 关闭自动提交 插入修改,只有commit 才最终存入
2) start transaction
commit/rollback
3) show variables like '%commit%'
4) 触发器:
create trigger name after/before insert/update/delete on 表名 for each row
begin
sql语句
end;
posted on 2019-01-17 16:15 xiaoliwm 阅读(61) 评论(0) 编辑 收藏 举报