Re: 1064 Error

[Marion Gordon]

The following query is helpful for creating the range to the table into MySQL database

mysql> CREATE TABLE range_partition_tab (
-> id numeric ,
-> data varchar(20),
-> insert_date date
-> )
-> PARTITION BY RANGE ( year (insert_date) ) (
-> PARTITION p1 VALUES LESS THAN (2005),
-> PARTITION p2 VALUES LESS THAN (2006),
-> PARTITION P3 VALUES LESS THAN MAXVALUE
-> );