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