利用mysql函数快速建立分表语句

BEGIN
#Routine body goes here…

declare i int;
declare num varchar(2);
set i=0;
set num = “0”;
while i<32 do
set num = concat("",i);
– IF i < 10 THEN
– set num = concat(“0”,i);
– END IF;
set @sql_drop_table = concat(
‘drop TABLE IF EXISTS t_user_’, num);
set @sql_create_table = concat(
‘CREATE TABLE IF NOT EXISTS t_user_’, num,
’ like sharding.t_user’);
PREPARE sql_drop_table FROM @sql_drop_table;
PREPARE sql_create_table FROM @sql_create_table;
EXECUTE sql_drop_table;
EXECUTE sql_create_table;

set i=i+1;
end while;

END