How to add and delete unique indexes for fields in MySQL

1. Add PRIMARY KEY (primary key index)

mysql>ALTER TABLE `table_name` ADD PRIMARY KEY (`column`)

2. Add UNIQUE (unique index)

mysql>ALTER TABLE `table_name` ADD UNIQUE ( `column` )

3. Add INDEX (normal index)

mysql>ALTER TABLE `table_name` ADD INDEX index_name (`column`)

4. Add FULLTEXT (full-text index)

mysql>ALTER TABLE `table_name` ADD FULLTEXT (`column`)

5. Add multi-column indexes

mysql>ALTER TABLE `table_name` ADD INDEX index_name ( `column1`, `column2`, `column3` )

The above method of adding and deleting unique indexes (unique) for fields in MySQL is all the content that the editor shares with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.