phpMyAdmin mysql Removing an index 删除唯一约束有大用

星期四, 2016-06-02 10:15 — adminshiping1

below the list of your "columns" in the table structure you have a small table called "Indexes". Every row is an index. Find there your unique index and drop it using "drop" symbol (red X). If you have it on more than one column then drop it and recreate without the column you don't want unique

answered Dec 1 '10 at 0:17

Michael Tabolsky

1,943198

Thanks Michael. All sorted. – Samuel Meddows Dec 1 '10 at 0:47

add a comment

up vote18down vote

Follow this steps:-

Click Structure tab of table.
Click Index(below the table).
Click Drop for remove index(s).

enter image description here

edited Mar 27 at 5:01

来自 http://stackoverflow.com/questions/4320005/phpmyadmin-removing-an-index

accepted

A unique constraint is also an index.

First use SHOW INDEX FROM tbl_name to find out the name of the index. The name of the index is stored in the column called key_name in the results of that query.

Then you can use DROP INDEX:

DROP INDEX index_name ON tbl_name

or the ALTER TABLE syntax:

ALTER TABLE tbl_name DROP INDEX index_name

edited Aug 15 '10 at 15:05

answered Aug 15 '10 at 14:15

Mark Byers

425k8210301158

Sorry sir i had tried it before raising the question ,but its not working – Ankur Mukherjee Aug 15 '10 at 14:26

@Ankur Mukherjee: I forgot to mention: You have to change tbl_name and index_name to the name of your actual table and the name of the actual index, respectively. You can see the names in MySQL Query Browser. You can also do SHOW CREATE TABLE tbl_name. – Mark Byers Aug 15 '10 at 14:33

Sir I know that very well and i had tried that only – Ankur Mukherjee Aug 15 '10 at 14:34

@Ankur Mukherjee: What is the error message that you get? – Mark Byers Aug 15 '10 at 14:51

Error Message:"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(player_id,year,tournament)' at line 1" – Ankur MukherjeeAug 15 '10 at 14:56

show 9 more comments

up vote63down vote

You can DROP a unique constraint from a table using phpMyAdmin as requested as shown in the table below. A unique constraint has been placed on the Wingspan field. The name of the constraint is the same as the field name, in this instance.

alt text

来自 http://stackoverflow.com/questions/3487691/dropping-unique-constraint-from-mysql-table

普通分类:

mysql

You are here

友情链接

搜索表单

用户登录

You are here

phpMyAdmin mysql Removing an index 删除唯一约束 有大用

友情链接

phpMyAdmin mysql Removing an index 删除唯一约束有大用