-
Notifications
You must be signed in to change notification settings - Fork 6
Closed
Labels
Milestone
Description
CREATE TABLE members (
firstname VARCHAR(25) NOT NULL,
lastname VARCHAR(25) NOT NULL,
username VARCHAR(16) NOT NULL,
email VARCHAR(35),
joined DATE NOT NULL
)
PARTITION BY RANGE( YEAR(joined) ) (
PARTITION p0 VALUES LESS THAN (1960),
PARTITION p1 VALUES LESS THAN (1970),
PARTITION p2 VALUES LESS THAN (1980),
PARTITION p3 VALUES LESS THAN (1990),
PARTITION p4 VALUES LESS THAN MAXVALUE
);mysql> show create table 0107_schema_partitions\G
*************************** 1. row ***************************
Table: 0107_schema_partitions
Create Table: CREATE TABLE `0107_schema_partitions` (
`firstname` varchar(25) NOT NULL,
`lastname` varchar(25) NOT NULL,
`username` varchar(16) NOT NULL,
`email` varchar(35) DEFAULT NULL,
`joined` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE ( YEAR(joined))
(PARTITION p0 VALUES LESS THAN (1960) ENGINE = InnoDB,
PARTITION p1 VALUES LESS THAN (1970) ENGINE = InnoDB,
PARTITION p2 VALUES LESS THAN (1980) ENGINE = InnoDB,
PARTITION p3 VALUES LESS THAN (1990) ENGINE = InnoDB,
PARTITION p4 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
1 row in set (0,00 sec)https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
Reactions are currently unavailable