My database MySQL already had some data inside.
I would like to change one field into unique field.
May I? and, how? Thanks.
field change into unique? MySQL
Moderator: General Moderators
-
x_mutatis_mutandis_x
- Forum Contributor
- Posts: 160
- Joined: Tue Apr 17, 2012 12:57 pm
Re: field change into unique? MySQL
First make sure the data in your column is unique. Assuming it is unique, then you can use the ALTER TABLE syntax:
Code: Select all
ALTER TABLE table_name ADD CONSTRAINT constraint_name UNIQUE (column_name)