Hi,
I need to make one field unique in a table.
The table description (show create table_name) already lists this field as being a KEY. I don't know what this means, but when I say:
"alter table table_name add unique (field_name);"
I get an error:
"ERROR 1061: Duplicate key name 'field_name'"
How may I make it unique?
I need to make one field unique in a table.
The table description (show create table_name) already lists this field as being a KEY. I don't know what this means, but when I say:
"alter table table_name add unique (field_name);"
I get an error:
"ERROR 1061: Duplicate key name 'field_name'"
How may I make it unique?