mysql 复合索引_Mysql复合索引的顺序和必要值

创建表：

CREATE TABLE article (

id INT (10) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

author_id INT (10) UNSIGNED NOT NULL,

category_id INT (10) UNSIGNED NOT NULL,

VIEW INT (10) UNSIGNED NOT NULL,

comments INT (10) UNSIGNED NOT NULL,

title VARBINARY (255) NOT NULL,

content text NOT NULL

);

插入数据：

INSERT INTO article (

author_id,

category_id. VIEW,

omments,

title,

content

)VALUES

(1, 1, 1, 1, '1', '1'),

(2, 2, 2, 2, '2', '2'),

(1,1,3,3,'3'，'3');

创建索引：

create index idx_articl_ccv on article(category_id,comments,view);

分析：

查询和排序字段正好符合索引--> 用到索引

explain select id,author_id from article where category_id = 1 and comments =1 order by view desc l