MySQL Forums
Forum List  »  Partitioning

How to ensure uniqueness of one column but partition by another key?
Posted by: Richard Xiong
Date: March 19, 2008 04:21PM

create table tp
id varchar(32) not null default '',
platTime datetime not null default '1000-01-01 00:00:00',
primary key (id),
type = InnoDB;

there is a primary key id, but I want to use platTime to partition the table, the condition is to ensure the uniqueness by id. How ?

Options: ReplyQuote

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.