Re: How to ensure uniqueness of one column but partition by another key?

[Phil Hildebrand]

Just add platTime to your primary key:

create table tp
(
id varchar(32) not null default '',
platTime datetime not null default '1000-01-01 00:00:00',
primary key (id,platTime)
)
type = InnoDB
PARTITION BY RANGE ( YEAR(platTime))
(PARTITION p0 VALUES LESS THAN (X),
PARTITION p1 VALUES LESS THAN (Y),
PARTITION p3 VALUES LESS THAN MAXVALUE)