Remove a configuration from a mysql column

0

I have a mysql column that has a key with value MUL , how to remove this setting from the command line?

My table has the following schema:

+-----------------+--------------+------+-----+-------------------+-----------------------------+
| Field           | Type         | Null | Key | Default           | Extra                       |
+-----------------+--------------+------+-----+-------------------+-----------------------------+
| imovel_id       | int(11)      | NO   | PRI | NULL              | auto_increment              |
| user_id         | int(11)      | NO   |     | NULL              |                             |
| img_dest        | varchar(111) | YES  |     | NULL              |                             |
| data_imob       | timestamp    | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| finalidade_imob | varchar(51)  | NO   | MUL | NULL              |                             |
| status_imob     | varchar(51)  | NO   |     | NULL              |                             |
| tipo_imob       | varchar(255) | YES  |     | NULL              |                             |
| uf_imob         | varchar(51)  | NO   | MUL | NULL              |                             |
| cidade_imob     | varchar(255) | NO   |     | NULL              |                             |
| bairro_imob     | varchar(255) | YES  |     | NULL              |                             |
| rua_imob        | varchar(255) | YES  |     | NULL              |                             |
| vaga_imob       | varchar(255) | YES  |     | NULL              |                             |
| dorms_imob      | char(2)      | YES  |     | NULL              |                             |
| tamanho_imob    | varchar(222) | YES  |     | NULL              |                             |
| valor_imob      | varchar(255) | YES  |     | 0                 |                             |
| titulo_imob     | varchar(255) | YES  |     | NULL              |                             |
| descricao_imob  | longtext     | YES  |     | NULL              |                             |
| carac_imob      | varchar(255) | YES  |     | NULL              |                             |
+-----------------+--------------+------+-----+-------------------+-----------------------------+
    
asked by anonymous 05.02.2018 / 18:34

1 answer

1

Just run an alter table, and drop the index from your table:

ALTER TABLE [nome_tabela] DROP INDEX [nome_index];

    
05.02.2018 / 19:29