开启事务:
START TRANSACTION;
提交事务:
COMMIT;
回滚事务:
ROLLBACK;
事务的概念:原子性,一致性,隔离性,持久性
READ UNCOMMITTED(读了未提交)
READ COMMITTED(读提交)
REPEATABLE READ (可重复读)
SERIALIZABLE(可串行化)
开启事务:
START TRANSACTION;
提交事务:
COMMIT;
回滚事务:
ROLLBACK;
事务的概念:原子性,一致性,隔离性,持久性
READ UNCOMMITTED(读了未提交)
READ COMMITTED(读提交)
REPEATABLE READ (可重复读)
SERIALIZABLE(可串行化)