Making a field unique

[DrumAt5280]

I have a table that has city names, some cities like Springfield occur in multiple states.

I use MySQL-Front for inputting my data. Anyone out there use this application too?

Can I get MySQL-Front to alert me when i have just entering an item that already exists with that field so I know to rename a city like Springfield-MO?

 

[TonyGroves]

I don't know anything about MySQL_Front, but you can define either a primary key or a unique index on the table, which will reject any attempt to insert a record with a duplicate value for the associated field:
[tt]
ALTER TABLE cities ADD UNIQUE (cityname);
[/tt]
or
[tt]
ALTER TABLE cities ADD PRIMARY KEY (cityname);
[/tt]