mysql remove unique constraint
ALTER TABLE tbl_name DROP INDEX index_namemysql remove unique constraint
ALTER TABLE tbl_name DROP INDEX index_namehow to create index mysql
# index_name will identify your index for future reference
CREATE INDEX index_name ON table_name (column_name);mysql set field unique
ALTER TABLE mytbl ADD UNIQUE (columnName);create index mysql
create index your_index_name on your_table_name(your_column_name) using HASH;
or
create index your_index_name on your_table_name(your_column_name) using BTREE;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
