Linux, FreeBSD, Juniper, Cisco / Network security articles and troubleshooting guides

It is currently Wed Jan 22, 2020 8:47 am

Message body:
Enter your message here, it may contain no more than 60000 characters. 

:D :) ;) :( :o :shock: :? 8-) :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :!: :?: :idea: :arrow: :| :mrgreen: :geek: :ugeek:
Font size:
Font colour
BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON
Disable BBCode
Disable smilies
Do not automatically parse URLs
Confirmation code
Confirmation code:
In an effort to prevent automatic submissions, we require that you enter both of the words displayed into the text field underneath.

Topic review - MySql drop unique key/index/constraint
Author Message
Post subject: fun movie  |  Post Posted: Wed Mar 23, 2011 8:39 pm
well, what I was searching for
Post subject: MySql drop unique key/index/constraint  |  Post Posted: Wed Feb 02, 2011 6:19 pm
To find out what unique indexes are in a table issue:
mysql> SHOW CREATE TABLE table_name
  UNIQUE KEY `unique_user` (`user`),

In the above case, there is a unique index / key named 'unique_user' on 'user' column.

To drop the unique key run:
mysql> ALTER TABLE table_name DROP INDEX unique_user;
Query OK, 6 rows affected (0.05 sec)
Records: 6  Duplicates: 0  Warnings: 0

Jump to:  
News News Site map Site map SitemapIndex SitemapIndex RSS Feed RSS Feed Channel list Channel list

Delete all board cookies | The team | All times are UTC - 5 hours [ DST ]