mysql存储过程多张表数据 mysql存储过程拼接sql

delimiter //
 create procedure sp_concat()
 begin
 declare v_date varchar(4000);
 declare v_sql varchar(4000);
 set v_date =(select date_format(now(),'%Y%m%d%H%s%i'));
 set @v_date =v_date;
 set v_sql = concat('create table kin_',@v_date,' (x int);');
 set @v_sql = v_sql;
 prepare stmt from @v_sql;
 execute stmt;
 end//delimiter ;