mysql> SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
Query OK, 0 rows affected (0.04 sec)

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

mysql> UPDATE users SET `name` = 'TungNT001' WHERE id = 1;
Query OK, 1 row affected (0.06 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> SELECT * FROM users;
+----+-----------+
| id | name      |
+----+-----------+
|  1 | TungNT001 |
|  2 | VienLD    |
|  3 | CuongPT   |
+----+-----------+
3 rows in set (0.02 sec)