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 ;