drop procedure if exists create_user_100;
delimiter $$
create procedure create_user_100()
begin
declare aa varchar(255);
declare i int default 1;
while i < 100 do
set aa=concat('user_',i);
set @usertable=concat(' create table ',aa,' like user');
prepare stm from @usertable;
execute stm;
set i=i+1;
end while;
end $$
delimiter ;
call create_user_100;
drop procedure if exists create_user_age;
delimiter $$
create procedure create_user_age()
begin
declare aa varchar(255);
declare i int default 1;
while i < 100 do
set aa=concat('user_',i);
set @usertable=concat(' alter table ',aa,' add `age` int(11) default null');
prepare stm from @usertable;
execute stm;
set i=i+1;
end while;
end $$
delimiter ;
call create_user_age;