Unset MUL KEY mysql

Asked Feb 05 '18 at 18:04

Active Feb 05 '18 at 18:04

Viewed 95 times

I have an columns with MUL in the KEY, i need unset that.

How unset KEY MUL in mysql command line?

+-----------------+--------------+------+-----+-------------------+-----------------------------+
| Field           | Type         | Null | Key | Default           | Extra                       |
+-----------------+--------------+------+-----+-------------------+-----------------------------+
| uf_imob         | varchar(51)  | NO   | MUL | NULL              |                             |
+-----------------+--------------+------+-----+-------------------+-----------------------------+

asked Feb 05 '18 at 18:04

MagicHat

Use `SHOW CREATE TABLE` to find out what's going on internally. – tadman Feb 05 '18 at 18:07
See https://stackoverflow.com/questions/5317889/sql-keys-mul-vs-pri-vs-uni for what `MUL` means, then it should be obvious what to do about it. – Barmar Feb 05 '18 at 18:08
@Barmar im new in mysql, i know now what `MUL` means but i still without knowing how unset that, u have any tip? – MagicHat Feb 05 '18 at 18:12
Use `ALTER TABLE` to change the indexes. – Barmar Feb 05 '18 at 18:16
Why do you want to unset it? – Barmar Feb 05 '18 at 18:16

Unset MUL KEY mysql

0 Answers0