如果会话在事务中途结束,当前 MySQL 事务会发生什么情况?

如果会话在事务中途结束,当前 MySQL 事务会发生什么情况?

示例

假设我们在表“marks”中有以下值

mysql> Select * from marks; +------+---------+-----------+-------+ | Id | Name | Subject | Marks | +------+---------+-----------+-------+ | 1 | Aarav | Maths | 50 | | 1 | Harshit | Maths | 55 | | 3 | Gaurav | Comp | 69 | | 4 | Rahul | History | 40 | | 5 | Yashraj | English | 48 | | 6 | Manak | History | 70 | +------+---------+-----------+-------+ 6 rows in set (0.00 sec) mysql> START TRANSACTION; Query OK, 0 rows affected (0.00 sec) mysql> UPDATE marks SET Name = ‘Yash’ Where id = 5; Query OK, 1 row affected (0.06 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> quit; Bye登录后复制

以上就是如果会话在事务中途结束,当前 MySQL 事务会发生什么情况?的详细内容,更多请关注每日运维网(www.mryunwei.com)其它相关文章!