MariaDB [bank]> select * from bank_accounts;
+------------------+-------------+
| bank_account | total_money |
+------------------+-------------+
| chulsoo_account | 10000 |
| younghee_account | 10000 |
+------------------+-------------+
2 rows in set (0.000 sec)
MariaDB [bank]> begin;
Query OK, 0 rows affected (0.000 sec)
MariaDB [bank]> UPDATE bank_accounts
SET total_money = total_money - 1000
WHERE bank_account = 'chulsoo_account';
Query OK, 1 row affected (0.001 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [bank]> select * from bank_accounts
-> ;
+------------------+-------------+
| bank_account | total_money |
+------------------+-------------+
| chulsoo_account | 9000 |
| younghee_account | 10000 |
+------------------+-------------+
2 rows in set (0.000 sec)
MariaDB [bank]> rollback;
Query OK, 0 rows affected (0.001 sec)
MariaDB [bank]> select * from bank_accounts;
+------------------+-------------+
| bank_account | total_money |
+------------------+-------------+
| chulsoo_account | 10000 |
| younghee_account | 10000 |
+------------------+-------------+
2 rows in set (0.000 sec)
