Example of creating an index in MySQL

MySQL index creation example environment: MySQL Sever 5.1 + MySQL command line tool problem: create index Syntax: CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] www.2cto.com ON tbl_name (index_col_name ,...) [index_type] index_col_name: col_name [(length)] [ASC | DESC] index_type: USING {BTREE | HASH | RTREE} example: [SQL] -- create table testIndex (id int not null primary key, name varchar (10); www.2cto.com -- create normal index creat E index IDX_test_testIndex _ Name on testIndex (name); Note: it is best to use this method for index naming: IDX_databaseName_tableName_columnName (IDX indicates index, databaseName indicates Database Name, tableName indicates table name, columnName indicates the field name. If there is no database concept in Oracle, replace it with the tablespace, so replace databaseName with the user name ). Reference: MySQL Create Index method and syntax structure and example http://www.bkjia.com/database/201209/155472.html