SET @sqlstr = CONCAT('create table TABLE_',DATE_FORMAT(CURDATE(),'%Y%m%d'),' (id int)');
PREPARE stmt1 FROM @sqlstr ;
EXECUTE stmt1 ;
例如:备份
SET @sqlstr = CONCAT(' CREATE TABLE sys_log',DATE_FORMAT(now(),'%Y%m') ,' AS SELECT * FROM sys_log ');
PREPARE stmt1 FROM @sqlstr ;
EXECUTE stmt1 ;