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

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

mysql> DELETE FROM users WHERE id = 3;
Query OK, 1 row affected (0.02 sec)

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