MySql中怎么创建事务? MySql中怎么创建事务? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 1. innodb的表引擎才支持事务。2. 如果使用事务。你可以参考一下官主文档中的例子。http://dev.mysql.com/doc/refman/5.1/zh/storage-engines.html#innodb-transaction-modelhttp://dev.mysql.com/doc/refman/5.1/zh/sql-syntax.html#transactional-commands13.4. MySQL事务处理和锁定语句13.4.1. START TRANSACTION, COMMIT和ROLLBACK语法13.4.2. 不能回滚的语句13.4.3. 会造成隐式提交的语句13.4.4. SAVEPOINT和ROLLBACK TO SAVEPOINT语法13.4.5. LOCK TABLES和UNLOCK TABLES语法13.4.6. SET TRANSACTION语法13.4.7. XA事务 mysql> select * from tester;+----+--------+--------------+--------+-------+--------+| ID | name | address | salary | grade | sex |+----+--------+--------------+--------+-------+--------+| 1 | jason | shenzhen | 4500 | 6 | male || 2 | linkle | zhuhai | 4000 | 5 | female || 3 | leo | zhuhai | 3000 | 4 | male || 5 | steven | zhuhai_jinan | 5600 | 7 | male || 6 | jacky | zhuhai | 4000 | 5 | male |+----+--------+--------------+--------+-------+--------+5 rows in set (0.00 sec)mysql> set autocommit=0;Query OK, 0 rows affected (0.00 sec)mysql> insert into tester values(7,'jack','HongKong',8000,10,'male');Query OK, 1 row affected (0.00 sec)mysql> rollback;Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> select * from tester;+----+--------+--------------+--------+-------+--------+| ID | name | address | salary | grade | sex |+----+--------+--------------+--------+-------+--------+| 1 | jason | shenzhen | 4500 | 6 | male || 2 | linkle | zhuhai | 4000 | 5 | female || 3 | leo | zhuhai | 3000 | 4 | male || 5 | steven | zhuhai_jinan | 5600 | 7 | male || 6 | jacky | zhuhai | 4000 | 5 | male || 7 | jack | HongKong | 8000 | 10 | male |+----+--------+--------------+--------+-------+--------+6 rows in set (0.00 sec) 按照上面的步骤rollback没有生效关于更多参考http://blog.csdn.net/nianzhang747/archive/2009/08/13/4441586.aspx start transaction;事务语句...commit(提交事务) or rollback(回滚事务) 求SQL语句,急!!!!! mysql存储过程查询插入问题 怎么去除数据库里面的重复记录 急求→两表关联求总数! mysql如何两表查询? count(distinct 慢查询语句如何改写? 用ODBC数据源建立MySQL数据连接的问题 两个数据库之间导数据 急!求助!关于MYSQL数据恢复的问题 MySQL存储函数中的参数传递问题 mysql capi和odbc update可以加强制索引?
2. 如果使用事务。你可以参考一下官主文档中的例子。http://dev.mysql.com/doc/refman/5.1/zh/storage-engines.html#innodb-transaction-model
http://dev.mysql.com/doc/refman/5.1/zh/sql-syntax.html#transactional-commands
13.4. MySQL事务处理和锁定语句
13.4.1. START TRANSACTION, COMMIT和ROLLBACK语法
13.4.2. 不能回滚的语句
13.4.3. 会造成隐式提交的语句
13.4.4. SAVEPOINT和ROLLBACK TO SAVEPOINT语法
13.4.5. LOCK TABLES和UNLOCK TABLES语法
13.4.6. SET TRANSACTION语法
13.4.7. XA事务
+----+--------+--------------+--------+-------+--------+
| ID | name | address | salary | grade | sex |
+----+--------+--------------+--------+-------+--------+
| 1 | jason | shenzhen | 4500 | 6 | male |
| 2 | linkle | zhuhai | 4000 | 5 | female |
| 3 | leo | zhuhai | 3000 | 4 | male |
| 5 | steven | zhuhai_jinan | 5600 | 7 | male |
| 6 | jacky | zhuhai | 4000 | 5 | male |
+----+--------+--------------+--------+-------+--------+
5 rows in set (0.00 sec)mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)mysql> insert into tester values(7,'jack','HongKong',8000,10,'male');
Query OK, 1 row affected (0.00 sec)mysql> rollback;
Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> select * from tester;
+----+--------+--------------+--------+-------+--------+
| ID | name | address | salary | grade | sex |
+----+--------+--------------+--------+-------+--------+
| 1 | jason | shenzhen | 4500 | 6 | male |
| 2 | linkle | zhuhai | 4000 | 5 | female |
| 3 | leo | zhuhai | 3000 | 4 | male |
| 5 | steven | zhuhai_jinan | 5600 | 7 | male |
| 6 | jacky | zhuhai | 4000 | 5 | male |
| 7 | jack | HongKong | 8000 | 10 | male |
+----+--------+--------------+--------+-------+--------+
6 rows in set (0.00 sec) 按照上面的步骤rollback没有生效
关于更多参考http://blog.csdn.net/nianzhang747/archive/2009/08/13/4441586.aspx
or
rollback(回滚事务)