mysql 表分区

分区类型：range list hash key

create table prange(id int primary key)engine=innodb partition by range(id)(partition p0 values less than(10),partition p1 values less than(20));

 create table orders(orderId int auto_increment,orderDate Datetime,primary key(orderId)) partition by range columns(orderDate)(partition p0 values less than('2021-01-01'),partition p1 values less than('2021-02-01'));