DELETE FROM TEST --不会影响自增 TRUNCATE TABLE TEST --自增会归零
delete和TRUNCATE的区别
原文:https://www.cnblogs.com/dearjohn/p/15032809.html