Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Mysql Command

Quote Reply
Mysql Command
This should be easy but can't think how to do it.

I want to add a unique index to my table but I can't use $editor->add_unique because there are already duplicate entries in the table that I want to be removed. So I need to run this mysql command:

ALTER IGNORE TABLE Tablename ADD UNIQUE INDEX(field1,field2);

Any idea how I can do this through links?
Subject Author Views Date
Thread Mysql Command afinlr 1421 Sep 29, 2004, 11:56 AM
Thread Re: [afinlr] Mysql Command
webmaster33 1362 Sep 29, 2004, 12:05 PM
Post Re: [webmaster33] Mysql Command
afinlr 1356 Sep 29, 2004, 12:22 PM