MySQL Forums
Forum List  »  MyISAM

Too many key parts specified; max 16 parts allowed.
Posted by: Abhishek Sahu
Date: July 27, 2016 05:40AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Too many key parts specified; max 16 parts allowed.
2164
July 27, 2016 05:40AM


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.