CREATE DEFINER=`root`@`%` PROCEDURE `BACKUP_STOCK_ACTUAL`()
BEGIN
SET @TABSUFFIX = DATE_FORMAT(DATE_ADD(NOW(),INTERVAL -1 day),'%Y%m%d');
SET @sqlstr = CONCAT('create table t_stock_actual_',@TABSUFFIX,' AS SELECT * FROM elfsack_central_pos.t_stock_actual');
PREPARE stmt1 FROM @sqlstr ;
EXECUTE stmt1 ;
SET @sqlstr_detail = CONCAT('create table t_stock_actual_detail_',@TABSUFFIX,' AS SELECT * FROM elfsack_central_pos.t_stock_actual_detail where CREATE_TIME BETWEEN DATE_ADD(NOW(),INTERVAL -1 day) AND NOW()');
PREPARE stmt2 FROM @sqlstr_detail ;
EXECUTE stmt2 ;
END
每天更新两张表到新的数据库