为所有表重置序列
DROP PROCEDURE IF EXISTS init_sql_string;
CREATE PROCEDURE init_sql_string()
BEGIN
DECLARE s int DEFAULT 0;
DECLARE sql_string varchar(256);
DECLARE report CURSOR FOR
SELECT
CONCAT( 'ALTER TABLE ', table_name, ' AUTO_INCREMENT = 1;' ) as sql_string
FROM
information_schema.TABLES
WHERE
table_schema = 'jdym';
DECLARE CONTINUE HANDLER FOR NOT FOUND SET s=1;
open report;
fetch report into sql_string;
while s <> 1 do
SET @run = sql_string;
PREPARE SQLStr1 FROM @run;
EXECUTE SQLStr1;
DEALLOCATE PREPARE SQLStr1;
fetch report into sql_string;
end while;
close report;
END;
call init_sql_string()