变量名做表明创建存储过程以及预编译语句
BEGINDECLARE a varchar(100);
SELECT CONCAT('a',right(rand(now()),3)) into a;
set @qs=CONCAT('CREATE table ', a,'
TYPE=MyISAM
SELECT * from tms_order limit 1',';');
PREPARE stmt1 from @qs;
EXECUTE stmt1 ;
set @qs2 = CONCAT('SELECT * from ',a);
PREPARE stm2 from @qs2 ;
EXECUTE stm2;
set @qs3 = CONCAT('drop table if EXISTS ',a,';');
PREPARE stm3 from @qs3;
EXECUTE stm3;
END
页:
[1]