mysqlパーティション

  ALTER TABLE sttrade5500.owner_order PARTITION BY RANGE (TO_DAYS(order_date)) (
   PARTITION P201807 VALUES LESS THAN (TO_DAYS(20180801)),
   PARTITION P201808 VALUES LESS THAN (TO_DAYS(20180901)),
   PARTITION P201809 VALUES LESS THAN (TO_DAYS(20181001)),
   PARTITION P0 VALUES LESS THAN MAXVALUE );