PARTITION BY RANGE

CREATE TABLE employees (
   id INT NOT NULL,
   fname VARCHAR(30),
   lname VARCHAR(30),
   hired DATE NOT NULL DEFAULT '1970-01-01',
   separated DATE NOT NULL DEFAULT '9999-12-31',
   job_code INT NOT NULL,
   store_id INT NOT NULL
)
PARTITION BY RANGE (store_id) (
   PARTITION p0 VALUES LESS THAN (6),
   PARTITION p1 VALUES LESS THAN (11),
   PARTITION p2 VALUES LESS THAN (16),
   PARTITION p3 VALUES LESS THAN (21)
);

See also

• CREATE TABLE, PARTITION BY { RANGE | LIST | HASH }
• Table, foreign table, external table, show table, Delete rows of a table, Table Partitioning (PARTITION BY RANGE), \dt, Hash table, CREATE TABLE, DROP TABLE, ALTER TABLE, SHOW TABLES, TRUNCATE