4
I created a table in Mysql that uses a column called loja_num
with the attribute key dish
UNIQUE KEY loja_num (loja_num,
But now, I would like to remove this attribute from this column. I have already done some searches without success. Does anyone know tell me which command I use in Mysql?
I use XAMPP on Windows and the database is Mysql.
Thank you.
Guys, forget it, forget it!! It was solved as follows: 1) I searched for the INDEXES that existed in the database: 'SHOW INDEXES FROM lojas_info;' Then I deleted the INDEX that contained the UNIQUE KEY: 'ALTER TABLE lojas_info DROP INDEX loja_num;'
– Igor Santana
If you have found the solution, post an answer to your own question.
– Victor Stafusa
@Igorsantana would be nice if you post the solution in the answer, so it would help future visitors with the same doubt.
– Bacco
But I posted up there... see: 1) I searched for the INDEXES that existed in the database: 'SHOW INDEXES FROM lojas_info;' Then I deleted the INDEX that contained the UNIQUE KEY: 'ALTER TABLE lojas_info DROP INDEX loja_num;'
– Igor Santana