CREATE DATABASE IF NOT EXISTS girls;

USE girls; CREATE TABLE account( id INT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(20), balance VARCHAR(20)

); TRUNCATE TABLE account; INSERT INTO account VALUES(NULL,‘令狐冲’,1000),(NULL,‘任盈盈’,1000);

SELECT * FROM account; #mysql默认情况下开启事物，每一条语句单独是一个事物。并且自动提交。

1、开启事务

取消隐式事务的自动提交功能

SHOW VARIABLES LIKE ‘autocommit’; SET autocommit = 0;#将自动提交关闭 START TRANSACTION;#【可选】

#2、编写事务使用到的sql语句

UPDATE account SET balance = 500 WHERE username = ‘令狐冲’; UPDATE account SET balance = 1500 WHERE username = ‘任盈盈’;

#3、结束事务 #COMMIT; ROLLBACK;#回滚

SELECT * FROM account;