mysql 做归档

-- 创建归档数据库
CREATE DATABASE archive_db;

-- 将数据从主数据库表归档到归档数据库表
INSERT INTO archive_db.archive_table (column1, column2, ...)
SELECT column1, column2, ...
FROM main_db.main_table
WHERE date_column < '2023-01-01';

-- 启用事件调度器
SET GLOBAL event_scheduler = ON;

-- 创建归档事件
CREATE EVENT archive_event
ON SCHEDULE EVERY 1 MONTH
DO
BEGIN
    INSERT INTO archive_db.archive_table (column1, column2, ...)
    SELECT column1, column2, ...
    FROM main_db.main_table
    WHERE date_column < DATE_SUB(CURDATE(), INTERVAL 1 MONTH);
END;

-- 查询主数据库和归档数据库的数据
SELECT main_db.main_table.column1, archive_db.archive_table.column2
FROM main_db.main_table
LEFT JOIN archive_db.archive_table
ON main_db.main_table.id = archive_db.archive_table.id
WHERE main_db.main_table.date_column < '2023-01-01';