可以,如:CREATE TABLE sales_by_day ( day DATE NOT NULL, product INT NOT NULL, sales DECIMAL(10, 2) NOT NULL, returns DECIMAL(10, 2) NOT NULL, PRIMARY KEY(day, product) ) ENGINE=MYISAM;ALTER TABLE sales_by_day PARTITION BY RANGE(YEARWEEK(day)) ( PARTITION p_200852 VALUES LESS THAN (200901), PARTITION p_200901 VALUES LESS THAN (200902), PARTITION p_200902 VALUES LESS THAN (200903), PARTITION p_catchall VALUES LESS THAN MAXVALUE );按月份分区
day DATE NOT NULL,
product INT NOT NULL,
sales DECIMAL(10, 2) NOT NULL,
returns DECIMAL(10, 2) NOT NULL,
PRIMARY KEY(day, product)
) ENGINE=MYISAM;ALTER TABLE sales_by_day
PARTITION BY RANGE(YEARWEEK(day)) (
PARTITION p_200852 VALUES LESS THAN (200901),
PARTITION p_200901 VALUES LESS THAN (200902),
PARTITION p_200902 VALUES LESS THAN (200903),
PARTITION p_catchall VALUES LESS THAN MAXVALUE );按月份分区