No, TRUNCATE is all or nothing. You can do a DELETE FROM <table> WHERE <conditions> but this loses the speed advantages of TRUNCATE.
TRUNCATE
DELETE FROM <table> WHERE <conditions>
TRUNCATE can't with condition
原文:https://www.cnblogs.com/kakaisgood/p/10066512.html