All is in the title :
ALTER IGNORE TABLE myTable ADD UNIQUE INDEX(myField1, myField2); |
And if you want to copy all a database into a new one :
CREATE TABLE myNewTable AS SELECT * FROM myTable; |
All is in the title :
ALTER IGNORE TABLE myTable ADD UNIQUE INDEX(myField1, myField2); |
And if you want to copy all a database into a new one :
CREATE TABLE myNewTable AS SELECT * FROM myTable; |