mysql添加索引

2/13/2017来源:SQL技巧人气:2266

ALTER TABLE `dbn_organization_relation_v` ADD INDEX cust_organization_id_index ( `cust_organization_id` );

其中dbn_organization_relation_v 是表名,cust_organization_id_index 是索引名称,cust_organization_id是需要添加索引的字段名称;