mysql常用命令

1.删除表中所有数据并清除自增长 从1开始

truncate table ad_particulars;

truncate table count_number;

truncate table jump_log;

truncate table leave_pv;

truncate table leave_uv;

truncate table mep;

truncate table monthly_bills;

truncate table price_day;

truncate table promote_data;

truncate table user_pv;

truncate table user_uv;
 

2.新增sql

alter table active add `delete_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '软删除';