truncate table [tablename]这个速度比较快delete from [tablename]这个是常规删除
delete from table where .....;
delete table where *********
不用那个 *
