ERROR 1070 (42000): Too many key parts specified; max 16 parts allowed

执行mysql 语句时出现

ERROR 1070 (42000): Too many key parts specified; max 16 parts allowed
表示 主键或索引的字段个数不能超过16个

实例：

CREATE TABLE test ( f1 INT, f2 INT, f3 INT, f4 INT, f5 INT, f6 INT, f7 INT, f8 INT, f9 INT, f10 INT, f11 INT, f12 INT, f13 INT, f14 INT, f15 INT, f16 INT, f17 INT );

create index idx_test_17 on test (f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12,f13,f14,f15,f16,f17);