mysql之savepoint

本文主要是介绍mysql之savepoint，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

demo

mysql> begin;
Query OK, 0 rows affected (0.00 sec)

mysql> select   * from planet_user_blacklist;
+----+----------+------------+------------+----------+---------------------------------+
| id | uid      | created_at | updated_at | add_type | address                         |
+----+----------+------------+------------+----------+---------------------------------+
|  1 | 29904034 |          1 |          2 |        0 | 广州市番禺区番禺广场1           |
|  2 |  2839939 |          2 |          2 |        0 | 广州市番禺区南村2               |
+----+----------+------------+------------+----------+---------------------------------+
2 rows in set (0.00 sec)

mysql> update planet_user_blacklist set updated_at = 100 where id = 1;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> savepoint test1;
Query OK, 0 rows affected (0.00 sec)

mysql> update planet_user_blacklist set updated_at = updated_at +1000 where id = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select   * from planet_user_blacklist;
+----+----------+------------+------------+----------+---------------------------------+
| id | uid      | created_at | updated_at | add_type | address                         |
+----+----------+------------+------------+----------+---------------------------------+
|  1 | 29904034 |          1 |       1100 |        0 | 广州市番禺区番禺广场1           |
|  2 |  2839939 |          2 |          2 |        0 | 广州市番禺区南村2               |
+----+----------+------------+------------+----------+---------------------------------+
2 rows in set (0.00 sec)

mysql> rollback to test1;
Query OK, 0 rows affected (0.00 sec)

mysql> update planet_user_blacklist set updated_at = updated_at +10000 where id = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select   * from planet_user_blacklist;
+----+----------+------------+------------+----------+---------------------------------+
| id | uid      | created_at | updated_at | add_type | address                         |
+----+----------+------------+------------+----------+---------------------------------+
|  1 | 29904034 |          1 |      10100 |        0 | 广州市番禺区番禺广场1           |
|  2 |  2839939 |          2 |          2 |        0 | 广州市番禺区南村2               |
+----+----------+------------+------------+----------+---------------------------------+
2 rows in set (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.01 sec)

mysql> select   * from planet_user_blacklist;
+----+----------+------------+------------+----------+---------------------------------+
| id | uid      | created_at | updated_at | add_type | address                         |
+----+----------+------------+------------+----------+---------------------------------+
|  1 | 29904034 |          1 |      10100 |        0 | 广州市番禺区番禺广场1           |
|  2 |  2839939 |          2 |          2 |        0 | 广州市番禺区南村2               |
+----+----------+------------+------------+----------+---------------------------------+
2 rows in set (0.00 sec)

这篇关于mysql之savepoint的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！