This community is for professionals and enthusiasts of our products and services.
Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.
在MYSQL下运行下面语句： alter table sap_tcodelogs drop PARTITION pmax ; alter table sap_tcodelogs add PARTITION ( PARTITION p202101 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-02-01 00:00:00') ), PARTITION p202102 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-03-01 00:00:00') ), PARTITION p202103 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-04-01 00:00:00') ), PARTITION p202104 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-05-01 00:00:00') ), PARTITION p202105 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-06-01 00:00:00') ), PARTITION p202106 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-07-01 00:00:00') ), PARTITION p202107 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-08-01 00:00:00') ), PARTITION p202108 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-09-01 00:00:00') ), PARTITION p202109 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-10-01 00:00:00') ), PARTITION p202110 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-11-01 00:00:00') ), PARTITION p203006 VALUES LESS THAN ( UNIX_TIMESTAMP('2030-07-01 00:00:00') ), PARTITION p203007 VALUES LESS THAN ( UNIX_TIMESTAMP('2030-08-01 00:00:00') ), PARTITION p203008 VALUES LESS THAN ( UNIX_TIMESTAMP('2030-09-01 00:00:00') ), PARTITION p203009 VALUES LESS THAN ( UNIX_TIMESTAMP('2030-10-01 00:00:00') ), PARTITION p203010 VALUES LESS THAN ( UNIX_TIMESTAMP('2030-11-01 00:00:00') ), PARTITION p203011 VALUES LESS THAN ( UNIX_TIMESTAMP('2030-12-01 00:00:00') ), PARTITION p203012 VALUES LESS THAN ( UNIX_TIMESTAMP('2031-01-01 00:00:00') ), PARTITION pmax VALUES LESS THAN (MAXVALUE) );
在MYSQL下运行下面语句：
alter table sap_tcodelogs drop PARTITION pmax ;
alter table sap_tcodelogs add PARTITION (
PARTITION p202101 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-02-01 00:00:00') ),
PARTITION p202102 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-03-01 00:00:00') ),
PARTITION p202103 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-04-01 00:00:00') ),
PARTITION p202104 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-05-01 00:00:00') ),
PARTITION p202105 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-06-01 00:00:00') ),
PARTITION p202106 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-07-01 00:00:00') ),
PARTITION p202107 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-08-01 00:00:00') ),
PARTITION p202108 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-09-01 00:00:00') ),
PARTITION p202109 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-10-01 00:00:00') ),
PARTITION p202110 VALUES LESS THAN ( UNIX_TIMESTAMP('2021-11-01 00:00:00') ),
PARTITION p203006 VALUES LESS THAN ( UNIX_TIMESTAMP('2030-07-01 00:00:00') ),
PARTITION p203007 VALUES LESS THAN ( UNIX_TIMESTAMP('2030-08-01 00:00:00') ),
PARTITION p203008 VALUES LESS THAN ( UNIX_TIMESTAMP('2030-09-01 00:00:00') ),
PARTITION p203009 VALUES LESS THAN ( UNIX_TIMESTAMP('2030-10-01 00:00:00') ),
PARTITION p203010 VALUES LESS THAN ( UNIX_TIMESTAMP('2030-11-01 00:00:00') ),
PARTITION p203011 VALUES LESS THAN ( UNIX_TIMESTAMP('2030-12-01 00:00:00') ),
PARTITION p203012 VALUES LESS THAN ( UNIX_TIMESTAMP('2031-01-01 00:00:00') ),
PARTITION pmax VALUES LESS THAN (MAXVALUE)
);