DELETE

CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, c1 INT NOT NULL);

Query OK, 0 rows affected (0.11 sec)

Query OK, 5 rows affected (0.03 sec)

SELECT * FROM t1;

Query OK, 1 row affected (0.02 sec)

+----+----+
| id | c1 |
+----+----+
|  1 |  1 |
|  3 |  3 |
|  5 |  5 |
+----+----+
4 rows in set (0.00 sec)

SELECT