SELECT
CONCAT( "alter table ", a.table_name, " auto_increment =1;" )
FROM
( SELECT table_name FROM information_schema.TABLES WHERE table_schema = 'fast_upms' ) AS a
WHERE
a.table_name LIKE "sys%";
fast_upms改为你的数据库名
sys%表示表前缀
SELECT
CONCAT( "alter table ", a.table_name, " auto_increment =1;" )
FROM
( SELECT table_name FROM information_schema.TABLES WHERE table_schema = 'fast_upms' ) AS a
WHERE
a.table_name LIKE "sys%";
fast_upms改为你的数据库名
sys%表示表前缀