TRUNCATE TABLE簡單使用

本次環境使用的是MySQL5.7版

1.清空該表中的所有數據
TRUNCATE TABLE tableName

mysql> SELECT * FROM Persons_copy;
+----------+----------+-----------+---------+------+
| PersonID | LastName | FirstName | Address | City |
+----------+----------+-----------+---------+------+
|       11 | Lester   | Mark      | No      | No   |
+----------+----------+-----------+---------+------+
1 row in set (0.00 sec)

mysql> TRUNCATE TABLE Persons_copy;
Query OK, 0 rows affected (0.14 sec)

mysql> SELECT * FROM Persons_copy;
Empty set (0.00 sec)