1、修改表名 alter table [old_name] rename [new_name] 2、清空表 delete from [tablename] 3、重置自增主键值 alter table [table_name] auto_increment=1