创建索引
Syntax:
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name
[index_type]
ON tbl_name (key_part,...)
[index_option]
[algorithm_option | lock_option] ...
key_part:
col_name [(length)] [ASC | DESC]
SQL执行顺序:
1、手写sql 顺序:
2、mysql服务器处理sql的顺序
求阴影部分: