给前缀相同的表添加相同的列

存储过程

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();