复制主表结构并创建
SET @sqlstr = CONCAT('create table covi_',DATE_FORMAT(CURDATE(),'%Y_%m_%d'),' like covi');
PREPARE stmt1 FROM @sqlstr ;
EXECUTE stmt1 ;
复制主表数据
SET @sqlstr = CONCAT('insert into covi_',DATE_FORMAT(CURDATE(),'%Y_%m_%d'),' select * from covi');
PREPARE stmt1 FROM @sqlstr ;
EXECUTE stmt1 ;