mysql创建分区表

CREATE TABLE IF NOT EXISTS chat_qa (

id INT AUTO_INCREMENT,

chat_session_id INT NOT NULL,

question TEXT NOT NULL,

answer TEXT NOT NULL,

asked_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,

answered_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (id, asked_at)

) PARTITION BY RANGE COLUMNS (asked_at) (

PARTITION p0 VALUES LESS THAN ('2023-01-01'),

PARTITION p1 VALUES LESS THAN ('2023-02-01'),

PARTITION p2 VALUES LESS THAN ('2023-03-01'),

PARTITION p3 VALUES LESS THAN ('2023-04-01')

);


 

CREATE TABLE IF NOT EXISTS chat_qa (
id INT AUTO_INCREMENT,
chat_sessions_id INT NOT NULL,
member_id INT NOT NULL,
question TEXT NOT NULL,
answer TEXT NOT NULL,
asked_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
answered_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id, asked_at)
) PARTITION BY RANGE COLUMNS (asked_at) (
PARTITION p0 VALUES LESS THAN ('2023-01-01'),
PARTITION p1 VALUES LESS THAN ('2023-02-01'),
PARTITION p2 VALUES LESS THAN ('2023-03-01'),
PARTITION p3 VALUES LESS THAN ('2023-04-01'),
PARTITION p4 VALUES LESS THAN ('2023-05-01'),
PARTITION p5 VALUES LESS THAN ('2023-06-01'),
PARTITION p6 VALUES LESS THAN ('2023-07-01'),
PARTITION p7 VALUES LESS THAN ('2023-08-01'),
PARTITION p8 VALUES LESS THAN ('2023-09-01'),
PARTITION p9 VALUES LESS THAN ('2023-10-01'),
PARTITION p10 VALUES LESS THAN ('2023-11-01'),
PARTITION p11 VALUES LESS THAN ('2023-12-01'),
PARTITION p12 VALUES LESS THAN ('2024-01-01'),
PARTITION p13 VALUES LESS THAN ('2024-02-01'),
PARTITION p14 VALUES LESS THAN ('2024-03-01'),
PARTITION p15 VALUES LESS THAN ('2024-04-01'),
PARTITION p16 VALUES LESS THAN ('2024-05-01'),
PARTITION p17 VALUES LESS THAN ('2024-06-01'),
PARTITION p18 VALUES LESS THAN ('2024-07-01'),
PARTITION p19 VALUES LESS THAN ('2024-08-01'),
PARTITION p20 VALUES LESS THAN ('2024-09-01'),
PARTITION p21 VALUES LESS THAN ('2024-10-01'),
PARTITION p22 VALUES LESS THAN ('2024-11-01'),
PARTITION p23 VALUES LESS THAN ('2024-12-01'),
PARTITION p24 VALUES LESS THAN ('2025-01-01'),
PARTITION p25 VALUES LESS THAN ('2025-02-01'),
PARTITION p26 VALUES LESS THAN ('2025-03-01'),
PARTITION p3 VALUES LESS THAN ('2025-04-01'),
PARTITION p3 VALUES LESS THAN ('2025-05-01'),
PARTITION p3 VALUES LESS THAN ('2025-06-01'),
PARTITION p3 VALUES LESS THAN ('2025-07-01'),
PARTITION p3 VALUES LESS THAN ('2025-08-01'),
PARTITION p3 VALUES LESS THAN ('2025-09-01'),
PARTITION p3 VALUES LESS THAN ('2025-10-01'),
PARTITION p3 VALUES LESS THAN ('2025-11-01'),
PARTITION p3 VALUES LESS THAN ('2025-12-01'),
PARTITION p3 VALUES LESS THAN ('2026-01-01'),
PARTITION p3 VALUES LESS THAN ('2026-02-01'),
PARTITION p3 VALUES LESS THAN ('2026-03-01'),
PARTITION p3 VALUES LESS THAN ('2026-04-01'),
PARTITION p3 VALUES LESS THAN ('2026-05-01'),
PARTITION p3 VALUES LESS THAN ('2026-06-01'),
PARTITION p3 VALUES LESS THAN ('2026-07-01'),
PARTITION p3 VALUES LESS THAN ('2026-08-01'),
PARTITION p3 VALUES LESS THAN ('2026-09-01'),
PARTITION p3 VALUES LESS THAN ('2026-10-01'),
PARTITION p3 VALUES LESS THAN ('2026-11-01'),
PARTITION p3 VALUES LESS THAN ('2026-12-01'),
PARTITION p3 VALUES LESS THAN ('2027-01-01'),
PARTITION p3 VALUES LESS THAN ('2027-02-01'),
PARTITION p3 VALUES LESS THAN ('2027-03-01'),
PARTITION p3 VALUES LESS THAN ('2027-04-01'),
PARTITION p3 VALUES LESS THAN ('2027-05-01'),
PARTITION p3 VALUES LESS THAN ('2027-06-01'),
PARTITION p3 VALUES LESS THAN ('2027-07-01'),
PARTITION p3 VALUES LESS THAN ('2027-08-01'),
PARTITION p3 VALUES LESS THAN ('2027-09-01'),
PARTITION p3 VALUES LESS THAN ('2027-10-01'),
PARTITION p3 VALUES LESS THAN ('2027-11-01'),
PARTITION p3 VALUES LESS THAN ('2027-12-01'),
PARTITION p3 VALUES LESS THAN ('2028-01-01'),
PARTITION p3 VALUES LESS THAN ('2028-02-01'),
PARTITION p3 VALUES LESS THAN ('2028-03-01'),
PARTITION p3 VALUES LESS THAN ('2028-04-01'),
PARTITION p3 VALUES LESS THAN ('2028-05-01'),
PARTITION p3 VALUES LESS THAN ('2028-06-01'),
PARTITION p3 VALUES LESS THAN ('2028-07-01'),
PARTITION p3 VALUES LESS THAN ('2028-08-01'),
PARTITION p3 VALUES LESS THAN ('2028-09-01'),
PARTITION p3 VALUES LESS THAN ('2028-10-01'),
PARTITION p3 VALUES LESS THAN ('2028-11-01'),
PARTITION p3 VALUES LESS THAN ('2028-12-01'),
PARTITION p3 VALUES LESS THAN ('2029-01-01'),
PARTITION p3 VALUES LESS THAN ('2029-02-01'),
PARTITION p3 VALUES LESS THAN ('2029-03-01'),
PARTITION p3 VALUES LESS THAN ('2029-04-01'),
PARTITION p3 VALUES LESS THAN ('2029-05-01'),
PARTITION p3 VALUES LESS THAN ('2029-06-01'),
PARTITION p3 VALUES LESS THAN ('2029-07-01'),
PARTITION p3 VALUES LESS THAN ('2029-08-01'),
PARTITION p3 VALUES LESS THAN ('2029-09-01'),
PARTITION p3 VALUES LESS THAN ('2029-10-01'),
PARTITION p3 VALUES LESS THAN ('2029-11-01'),
PARTITION p3 VALUES LESS THAN ('2029-12-01'),
PARTITION p3 VALUES LESS THAN ('2030-01-01'),
PARTITION p3 VALUES LESS THAN ('2030-02-01'),
PARTITION p3 VALUES LESS THAN ('2030-03-01'),
PARTITION p3 VALUES LESS THAN ('2030-04-01'),
PARTITION p3 VALUES LESS THAN ('2030-05-01'),
PARTITION p3 VALUES LESS THAN ('2030-06-01'),
PARTITION p3 VALUES LESS THAN ('2030-07-01'),
PARTITION p3 VALUES LESS THAN ('2030-08-01'),
PARTITION p3 VALUES LESS THAN ('2030-09-01'),
PARTITION p3 VALUES LESS THAN ('2030-10-01'),
PARTITION p3 VALUES LESS THAN ('2030-11-01'),
PARTITION p3 VALUES LESS THAN ('2030-12-01'),
);