MySQL Forums
Forum List  »  Partitioning

Partition
Posted by: Dhileepan M
Date: August 10, 2012 12:37AM

I need to create the table in the below format. But, It is returning Error Code: 1486. Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed. How can I recover from this and create the table ?

CREATE TABLE `tbl_emp_confirmation` (`fld_id` int(11) NOT NULL AUTO_INCREMENT,
`fldemp_id` varchar(100) DEFAULT NULL,
`fldempname` varchar(100) DEFAULT NULL,
`fldjoindate` varchar(100) DEFAULT NULL,
`fldconfirmdate` varchar(100) DEFAULT NULL,
`fldresigndate` varchar(100) DEFAULT NULL,
`fldstatus` varchar(50) DEFAULT NULL,
`fldcon_status` varchar(100) DEFAULT NULL,
UNIQUE KEY `fld_id` (`fld_id`), KEY `in_empconfirmation`
(`fldemp_id`,`fldempname`,`fldjoindate`,`fldconfirmdate`))

PARTITION BY RANGE ( Month(fldconfirmdate))
(
PARTITION p_JAN VALUES LESS THAN (2012-02-01),
PARTITION p_FEB VALUES LESS THAN (2012-03-01),
PARTITION p_MAR VALUES LESS THAN (2012-04-01),
PARTITION p_MAX VALUES LESS THAN MAXVALUE
);

Options: ReplyQuote


Subject
Views
Written By
Posted
Partition
2741
August 10, 2012 12:37AM
1669
August 11, 2012 03:37AM
1472
August 19, 2012 03:18PM


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.