存储过程
drop procedure if exists taskAddFieldPro;
CREATE PROCEDURE taskAddFieldPro()
BEGIN
DECLARE tableName CHARACTER(50);
DECLARE done INT DEFAULT FALSE;
DECLARE taskCursor CURSOR FOR select userName from user; /**从user表中查出username作为前缀相同表的不同后缀名*/
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
OPEN taskCursor;
read_loop:LOOP
FETCH NEXT from taskCursor INTO tableName;
IF done THEN
LEAVE read_loop;
ELSE
set @sql=concat('alter table uuu_',tableName,' add column isSuccess int(11) default 1');
PREPARE stmt from @sql;
execute stmt;
END IF;
END LOOP;
CLOSE taskCursor;
END;
CALL taskAddFieldPro();