Hands-On Exploration of MySQL Transaction Control
Environment
mysql> SELECT VERSION();
+------------+
| VERSION() |
+------------+
| 5.5.37-log |
+------------+
Preparing the Test Case
mysql> CREATE TABLE trx_demo(
pk INT PRIMARY KEY,
tag VARCHAR(20)
) ENGINE=InnoDB;
Query OK, 0 rows affected (0.29 sec)
mysql> SHOW TABLE STATUS LIKE 'trx_demo'\G
****** ...
Posted on Tue, 30 Jun 2026 16:44:28 +0000 by canny