DROP TABLE employees;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 DATETIME
)
PARTITION BY RANGE (store_id) (
PARTITION p0 VALUES LESS THAN ('2011-01-01 00:00:00'),
PARTITION p1 VALUES LESS THAN ('2012-01-01 00:00:00'),
PARTITION p3 VALUES LESS THAN ('2099-01-01 00:00:00')
);Query : drop table employeesError Code : 1051
Unknown table 'employees'Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
---------------------------------------------------Query : CREATE TABLE employees ( id INT NOT NULL, fname VARCHAR(30), lname VARCHAR(30), hired DATE NOT NULL DEFAULT '197...Error Code : 1064
VALUES value must be of same type as partition function near '),
PARTITION p1 VALUES LESS THAN ('2012-01-01 00:00:00'),
PARTITION p3 V' at line 11Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
---------------------------------------------------
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 DATETIME
)
PARTITION BY RANGE (store_id) (
PARTITION p0 VALUES LESS THAN ('2011-01-01 00:00:00'),
PARTITION p1 VALUES LESS THAN ('2012-01-01 00:00:00'),
PARTITION p3 VALUES LESS THAN ('2099-01-01 00:00:00')
);Query : drop table employeesError Code : 1051
Unknown table 'employees'Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
---------------------------------------------------Query : CREATE TABLE employees ( id INT NOT NULL, fname VARCHAR(30), lname VARCHAR(30), hired DATE NOT NULL DEFAULT '197...Error Code : 1064
VALUES value must be of same type as partition function near '),
PARTITION p1 VALUES LESS THAN ('2012-01-01 00:00:00'),
PARTITION p3 V' at line 11Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
---------------------------------------------------
另外日期好像无法做分区。
year