Add UNIQUE constraint to column in MySQL

December 6, 2011 at 4:34 am Leave a comment

Add UNIQUE Constraint

ALTER TABLE

ADD CONSTRAINT UNIQUE ()

Remove UNIQUE Constraint

ALTER TABLE

DROP INDEX ()

To add through Query browser GUI .

Select the Table , right click and edit
Then select the column to add the unique constraint , select “Indices” tab next to “Column details” , click the plus (+) button and add the constraint you need.

Advertisement

Entry filed under: tips and tricks. Tags: , , .

Could not find the main class. Program will exit.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


December 2011
M T W T F S S
« Jan    
 1234
567891011
12131415161718
19202122232425
262728293031  

Pages


Follow

Get every new post delivered to your Inbox.