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)
上一篇:DEALLOCATE
下一篇:DESC