mysql navicat 组合索引_mysql 索引 (Navicat添加索引)

索引类型：NORMAL 索引方法：BTREE

一般这样子设置就OK了

一.sql查询语句

SELECT

bp.id AS post_id,

`bp`.`title`,

bp.img AS bbs_img,

`bp`.`content`,

`bp`.`follow`,

`bp`.`reply`,

`bp`.`top`,

`bp`.`time`,

`bp`.`click`,

`u`.`nickname`,

`u`.`img`,

u.id AS uid,

bpf.id AS follow_id,

`bu`.`is_moderator`,

`bp`.`up`,

`bp`.`down`,

`pu`.`type`

FROM

`edu_bbs_post` `bp`

INNER JOIN `edu_user` &#