MySQL Forums
Forum List  »  Partitioning

Re: Unable to create partition InnoDB
Posted by: Samad Ul Haq
Date: November 02, 2017 01:55PM

This part made me think

Each of the following statements is valid, and represents one way in which the corresponding invalid table creation statement could be made to work:
CREATE TABLE t1 (
col1 INT NOT NULL,
col2 DATE NOT NULL,
col3 INT NOT NULL,
col4 INT NOT NULL,
UNIQUE KEY (col1, col2, col3)
)
PARTITION BY HASH(col3)
PARTITIONS 4;

above table doesn't have any primary key,but has unique key. Whereas in my case i have only primary key on 'id'.

Thats why i asked such question.

Regards
Samad

Options: ReplyQuote


Subject
Views
Written By
Posted
2654
November 02, 2017 02:50AM
1020
November 02, 2017 09:12AM
927
November 02, 2017 12:57PM
1093
November 02, 2017 01:16PM
Re: Unable to create partition InnoDB
975
November 02, 2017 01:55PM


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.