MySql 按月自动创建表分区 详细完整步骤
从创建分区表,自动分区存储过程,到定时任务创建
1.先建立一张测试用的分区表
#创建带分区的测试表
CREATE TABLE `test` (
`date` datetime NOT NULL DEFAULT NOW(),
`testname` int(10) DEFAULT NULL,
`id` bigint(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`, `date`),
KEY `date_index` (`date`)
)ENGINE=INNODB DEFAULT CHARSET=latin1
#根据月分区
PARTITION BY RANGE (to_days(date)) (
PARTITION p202301 VALUES LESS THAN (to_days('2023-01-01')),
PARTITION p202302 VALUES LESS THAN (to_days('2023-02-01'