MYSQL DATETIME字段分区

最新推荐文章于 2024-04-19 22:55:54 发布

AI小白白猫

最新推荐文章于 2024-04-19 22:55:54 发布

阅读量301

点赞数

文章标签： mysql android 数据库

本文链接：https://blog.youkuaiyun.com/weixin_46449024/article/details/131858881

版权

CREATE TABLE `test_part2` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
`col1` varchar(10) NOT NULL DEFAULT '' COMMENT 'col1',
`col2` varchar(10) NOT NULL DEFAULT '' COMMENT 'col2',
`col3` varchar(10) NOT NULL DEFAULT '' COMMENT 'col3',
`a_date` datetime  NOT NULL DEFAULT '20210816' COMMENT '日期',
PRIMARY KEY (`id`,`a_date`)
 ) ENGINE=InnoDB CHARSET=utf8mb4 COMMENT='test'
partition by range(to_days(a_date))
 (
PARTITION p20211229 VALUES LESS THAN (TO_DAYS('20211229')),
PARTITION p20211230 VALUES LESS THAN (TO_DAYS('20211230')),
PARTITION p20211231 VALUES LESS THAN (TO_DAYS('20211231')),
PARTITION p20220101 VALUES LESS THAN (TO_DAYS('20220101'))
 );