Too many key parts specified; max 16 parts allowed.
Hello Every One,
I am using mysql 5.6 and I get "Too many key parts specified; max 16 parts allowed Error No 1070" on Employee table when I try to add UNIQUE INDEX on more than 16 columns.
SQL:- ALTER IGNORE TABLE OUTPUT_2300 Add UNIQUE INDEX INDEX2300 (col1 ,col2...)
Is there any way to change/configure mysql to increase the number of key parts ?
Early response will be highly appreciated.
Thanks ,
Abhishek Sahu
Subject
Views
Written By
Posted
Too many key parts specified; max 16 parts allowed.
5319
July 27, 2016 05:40AM
3542
July 29, 2016 05:10PM
2632
July 31, 2016 04:35AM
2101
August 01, 2016 10:33AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.