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)