数据表数据定时备份

-- 创建存储过程
create PROCEDURE pr_backup_logs()
BEGIN

DECLARE carr_time VARCHAR(50);
set carr_time = concat(date_sub(curdate(),interval 7 day), " 00:00:00");

SET @STMT =CONCAT("CREATE TABLE pr_backup_logs_",DATE_FORMAT(NOW(),"%Y%m%d%h%i")," SELECT * FROM logs where SaveTime < ", carr_time); 

PREPARE STMT FROM @STMT; 

EXECUTE STMT;

DELETE from logs where SaveTime < carr_time;

END
-- 执行存储过程
call pr_backup_logs();
-- 删除存储过程
DROP PROCEDURE pr_backup_logs;