Shulou(Shulou.com)06/01 Report--

MySQL creates and deletes indexes

Create a normal index:

Alter table student add index index_dept (dept (8))

Create a unique index

Create unique index uni_ind_name on student (name)

Create an index based on the first n characters of the column

Create index index_dept on student (dept (8))

Create a federated index based on multiple columns

Create index ind_name_dept on student (name,dept)

Create a federated index based on the first n characters of multiple columns

Create index ind_name_dept on student (name (8), dept (10))

Delete a normal index

Alter table student drop index index_dept

Drop index index_dept on student

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.