Skip navigation links

MySQL Forums


Advanced Search

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: Reply•Quote


Subject Views Written By Posted
How to ensure uniqueness of one column but partition by another key? 1725 Richard Xiong 03/19/2008 04:21PM
Re: How to ensure uniqueness of one column but partition by another key? 1217 Phil Hildebrand 03/19/2008 08:49PM
Re: How to ensure uniqueness of one column but partition by another key? 1185 Richard Xiong 03/22/2008 09:57AM
Re: How to ensure uniqueness of one column but partition by another key? 1209 Phil Hildebrand 03/22/2008 10:53PM
Re: How to ensure uniqueness of one column but partition by another key? 1185 Richard Xiong 03/23/2008 02:20AM
Re: How to ensure uniqueness of one column but partition by another key? 1297 Phil Hildebrand 03/23/2008 01:55PM


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