MySQL语法自动提交与手动提交的基本语法示例

MySQL手动提交语法​示例

//关闭自动提交
SET autocommit = 0;

//开始事务
BEGIN;
 
UPDATE example_table SET name = 'xiaomi' WHERE id = 1;
DELETE FROM example_table WHERE id = 2;

//这时数据还未提交，查询结果不包含最新的修改
SELECT * FROM example_table;

//提交事务
COMMIT;

//这时数据已提交，查询结果包含最新的修改
SELECT * FROM example_table;

MySQL自动提交语法示例​

CREATE TABLE example_table (
  id INT PRIMARY KEY,
  name VARCHAR(50)
);
 
INSERT INTO example_table VALUES (1, 'xiaomi');
INSERT INTO example_table VALUES (2, 'xiaohua');
 
SELECT * FROM example_table;