MYSQL 多表批量新增字段

一、navicat中新建procedure

CREATE DEFINER=`portal`@`%` PROCEDURE `pro_AddColumn`(
	IN tab VARCHAR(100)
)
BEGIN
IF NOT EXISTS(SELECT 1 FROM information_schema.columns WHERE table_name=tab AND COLUMN_NAME='CREATE_DATE') THEN
SET @exe = CONCAT('ALTER TABLE ',tab," ADD CREATE_DATE DATE COMMENT '创建时间'");
PREPARE sql1 FROM @exe;
EXECUTE sql1;
END IF;
IF NOT EXISTS(SELECT 1 FROM information_schema.columns WHERE table_name=tab AND COLUMN_NAME='CREATE_USER') THEN
SET @exe = CONCAT('ALTER TABLE ',tab," ADD CREATE_