topic simple question...mysql+unique in Operating System - HP-UX

simple question...mysql+unique

amonamon — Mon, 10 Jul 2006 05:20:22 GMT

Helooo,

I have table like this:

CREATE TABLE `actions` (
`id` INT NOT NULL AUTO_INCREMENT ,
`date` INT NOT NULL ,
`time` INT NOT NULL ,
`comp` VARCHAR( 10 ) NOT NULL ,
`target` VARCHAR( 20 ) NOT NULL ,
`action` VARCHAR( 100 ) NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE (`id`)
);

Also I have some data in that table but unique field is just id..I have some duplicated data there and I would like to have table like this:

CREATE TABLE `actions` (
`id` INT NOT NULL AUTO_INCREMENT ,
`date` INT NOT NULL ,
`time` INT NOT NULL ,
`comp` VARCHAR( 10 ) NOT NULL ,
`target` VARCHAR( 20 ) NOT NULL ,
`action` VARCHAR( 100 ) NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE (`id`) ,
UNIQUE (`time`)
);

so in this case it would not allow insert records with a same time value..

is there a way other then to drop and create again table and new insert..??

any ideas??

Re: simple question...mysql+unique

Peter Godron — Mon, 10 Jul 2006 05:55:51 GMT

Hi,
have you tried:
alter table actions drop primary key;
alter table actions add primary key unique id, unique time;

Re: simple question...mysql+unique

amonamon — Mon, 10 Jul 2006 06:33:29 GMT

welll firs command passed but second did not...

any ideas????

Re: simple question...mysql+unique

amonamon — Mon, 10 Jul 2006 06:47:39 GMT

O well I dropped table and I created it again and insert data in it..