mysql> show tables;
+------------------+
| Tables_in_dircms |
+------------------+
| user |
+------------------+
1 row in set (0.01 sec)mysql> begin;
Query OK, 0 rows affected (0.00 sec)mysql> drop table if exists `user`;mysql> rollback;
Query OK, 0 rows affected (0.03 sec)mysql> show tables;
Empty set (0.00 sec)
请问事物处理都支持哪些操作呢?为什么drop操作不能回滚呢?还有那些类似操作不能回滚呢?
+------------------+
| Tables_in_dircms |
+------------------+
| user |
+------------------+
1 row in set (0.01 sec)mysql> begin;
Query OK, 0 rows affected (0.00 sec)mysql> drop table if exists `user`;mysql> rollback;
Query OK, 0 rows affected (0.03 sec)mysql> show tables;
Empty set (0.00 sec)
请问事物处理都支持哪些操作呢?为什么drop操作不能回滚呢?还有那些类似操作不能回滚呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货