mysql让自增主键从1开始

重置已有数据主键
set @rownum = 0;
update bassec set id= @rownum := @rownum+1;

修改自增主键的起始值
alter table bassec auto_increment = 1