1、在EXCEL中生成所需SQL语句
alter table friend0 add column pknum int;
alter table friend99 add column pknum int;
2、用SP循环生成
alter table friend0 add column pknum int;
SQL语句,再动态执行
DELIMITER $$
CREATE PROCEDURE dd1()
BEGIN
DECLARE i INT DEFAULT 0;
WHILE i<=99 DO
SET @s=CONCAT('alter table friend',i,' add column pknum int;');
PREPARE stml FROM @s;
EXECUTE stml;
END WHILE;
END; $$
DELIMITER ;
温馨提示:答案为网友推荐,仅供参考