MySQL Forums
Forum List  »  MySQL for Excel

Re: 1064 Error
Posted by: Marion Gordon
Date: August 24, 2014 11:35PM

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
-> );

Options: ReplyQuote


Subject
Views
Written By
Posted
2653
July 15, 2014 11:59PM
1410
July 16, 2014 11:05AM
Re: 1064 Error
1257
August 24, 2014 11:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.