What is the use of "Partition" keyword in MySQL?
Posted
by chandru_cp
on Stack Overflow
See other posts from Stack Overflow
or by chandru_cp
Published on 2010-04-01T11:12:48Z
Indexed on
2010/04/03
17:53 UTC
Read the original article
Hit count: 173
As I am a MySQL newbie. What does PARTITION mean in this MySQL statement?
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)
);
© Stack Overflow or respective owner
