MySQ存储过程字符串拼接问题

Question

create procedure create_table()
begin
    declare i int;
    declare t_name varchar(40);
    set i=1;
    while i<64 do
        set t_name = concat("thread_board_mapping",i);
         CREATE TABLE t_name(
        `tid` bigint(20) unsigned NOT NULL COMMENT '主题ID',
        `bid` bigint(20) unsigned NOT NULL COMMENT '专辑ID',
        `created_at` timestamp NOT NULL DEFAULT '1970-01-01 08:00:01' COMMENT '创建时间',
     `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
     PRIMARY KEY (`bid`,`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='帖子专辑关系表，按tid分表';
         set i=i+1;
     end while;
end; 

 t_name 我的表名想用 变量i 和固定部分(thread_board_mapping) 来拼接

Answer 1

擦，被你抢先了，正解！

Answer 2

回复
这段时间比较空 呵呵

Answer 3

用预编译语句绕一下可以实现，例子参考

SET @DYNAMICSQL = CONCAT('select * from ', tableName,' order by create_date');  
PREPARE statement FROM @DYNAMICSQL;  
EXECUTE statement;