Linux, FreeBSD, Juniper, Cisco / Network security articles and troubleshooting guides
https://forum.ivorde.com/

MySql drop unique key/index/constraint
https://forum.ivorde.com/mysql-drop-unique-key-index-constraint-t147.html
Page 1 of 1

Author:  admin [ Wed Feb 02, 2011 6:19 pm ]
Post subject:  MySql drop unique key/index/constraint

To find out what unique indexes are in a table issue:
Code:
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:
Code:
mysql> ALTER TABLE table_name DROP INDEX unique_user;
Query OK, 6 rows affected (0.05 sec)
Records: 6  Duplicates: 0  Warnings: 0


Author:  dugEdiguift [ Wed Mar 23, 2011 8:39 pm ]
Post subject:  fun movie

well, what I was searching for

Page 1 of 1 All times are UTC - 5 hours [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/