记录一些比较容易忘记的sql语句 不定时更新整合
1.将整张数据表彻底清空(包括自增主键的重置)
truncate table table_name
2.只清空当前数据
delete from table_name
DROP TABLE table_name
update table_name set property_name = new_value where *** = ***