存储过程分表

DROP PROCEDURE IF EXISTS `test_sql`; 
create procedure test_sql(in start_num int, in end_num int)
begin
declare i int;
set i=start_num;
while i<end_num+1 do
set @sql_create_table = concat(
'CREATE TABLE IF NOT EXISTS wx_pay_order_', i,
"(
 `id` bigint(20) NOT NULL,
  `transaction_id` varchar(45) DEFAULT NULL COMMENT '微信支付订单号',
  `wx_isv_id` bigint(20) NOT NULL DEFAULT '1',
  `return_msg` varchar(45) DEFAULT NULL COMMENT '返回信息',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单表'
");
PREPARE sql_create_table FROM @sql_create_table;   
EXECUTE sql_create_table;
set i=i+1;
end while;
end;
CALL test_sql(2,5);