在MySQL中删除数据有两种方式:truncate(截短)属于粗暴型的清空delete属于精细化的删除删除操作如果你需要清空表里的所有数据,下面两种均可:delete from tablename;truncate table tablename;而如果你只是删除一部分数据,就只能使用delete:de..
复制代码 代码如下:TRUNCATE TABLE (Transact-SQL)Removes all rows from a table without logging the individual row deletions. TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause; however, TRUNCATE TABLE is faster a..