Mysql修改Auto_increment

1

select auto_increment from information_schema.tables where table_schema='xxx_db' and table_name='xxx'; 

1

alter table xxx_db.xxx auto_increment=1000;