MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
Posted by: Peter Brawley
Date: July 01, 2019 09:39AM

> If someone can tell me how to increase the key parts
> limit of MySQL that will be really helpful for me.

It is not a user-modifiable limit. You would have to edit the source code of your server, recompile, regression test, and repeat that every time you upgrade.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
4324
sanjb c
June 28, 2019 06:53AM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
3721
Peter Brawley
June 28, 2019 11:03AM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
1558
sanjb c
June 28, 2019 10:22PM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
2255
Peter Brawley
June 29, 2019 12:12PM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
1571
sanjb c
July 01, 2019 03:01AM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
1917
Peter Brawley
July 01, 2019 09:39AM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
3921
Lucas van Staden
November 27, 2019 07:14AM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
1706
Lucas van Staden
November 27, 2019 07:34AM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
1536
Efecan Bilge
November 05, 2019 10:43PM
Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
1186
Peter Brawley
November 06, 2019 10:15AM


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.