partition_by_range.sql

CREATE TABLE `samples` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `comment` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`,`created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
PARTITION BY RANGE COLUMNS(`created`) (
PARTITION samples_p20170427 VALUES LESS THAN('2017-04-28 00:00:00'),
PARTITION samples_p20170428 VALUES LESS THAN('2017-04-29 00:00:00')
);

-- ALTER TABLE `samples`
-- PARTITION BY RANGE COLUMNS(`created`) (
-- PARTITION samples_p20170429 VALUES LESS THAN('2017-04-30 00:00:00')
-- );


ALTER TABLE `samples` ADD PARTITION (
PARTITION samples_p20170430 VALUES LESS THAN('2017-05-01 00:00:00')
);