1.建表时,引擎选用innodb ##表的默认引擎就是innodb,不写engine=innodb时,也支持事务。2.开启事务引擎 start transaction3.写要用的sql语句4.提交commit 或者回滚 rollback注意:commit/rollback后,开启的事务就结束了。注意:有一些语句会造成事务的隐式的提交,比如 start transaction------------------------create table thing(id int,name char(5),money int)engine=innodb charset utf8; #表的默认引擎就是innodb,不写engine=innodb时,也支持事务。insert into thing values(1,"张三",3000),(2,"李四",3000);start transaction;update thing set money=money-500 where id=1;update thing set money=money+500 where id=2;commit;----------------------------------建表时,engine=myisam,那么就不支持事务:create table myisamThing(id int primary key auto_increment,name char(6),money int not null default 3000)engine=myisam charset utf8;insert into myisamThing (name)values("张三"),("李四");