MySQL CreateIndex method and syntax structure and example

MySQL CreateIndex method and syntax structure and example

MySQL Create Index method and syntax structure and example

Create index Syntax

CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name
[Index_type]
ON tbl_name (index_col_name ,...)
[Index_type]

Index_col_name:
Col_name [(length)] [ASC | DESC]

Index_type:
USING {BTREE | HASH | RTREE}
The Code is as follows:
-- Create a table without Indexes
Create table testNoPK (
Id int not null,
Name varchar (10)
);
-- Create a common index
Create index IDX_testNoPK_Name on testNoPK (name );