CREATE INDEX index_name ON table_name(column_list);
例:
CREATE TABLE account_info
(
id
int(11) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
create_time
datetime(0) NULL DEFAULT NULL COMMENT ‘创建时间’,
update_time
datetime(0) NULL DEFAULT NULL COMMENT ‘更新时间’,
user_id
int(11) NOT NULL COMMENT ‘用户信息id’,
account_type
int(2) NOT NULL COMMENT ‘账号类型 1-手机号,2-微信,3-qq’,
user_type
int(2) NOT NULL COMMENT ‘用户类型 0-普通,1-vip’,
account_name
VARCHAR(64) NOT NULL COMMENT ‘账号名称’,
password
VARCHAR(64) NOT NULL COMMENT ‘账号密码’,
is_delete
int(1) NOT NULL COMMENT ‘是否删除 0-否 1-是’,
PRIMARY KEY (id
) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
给user_id创建索引:
CREATE INDEX index_user_id ON account_info (user_id);