mysql 多字段联合唯一索引
6个字段组成联合唯一索引
索引名称code_level_metric_type_week_year
sql语句联合索引
CREATE UNIQUE INDEX code_level_metric_type_week_year
ON dept_utilization (dept_code,dept_level,metric,statistical_type,week_of_year,year);
原创:做时间的朋友
索引名称code_level_metric_type_week_year
CREATE UNIQUE INDEX code_level_metric_type_week_year
ON dept_utilization (dept_code,dept_level,metric,statistical_type,week_of_year,year);