MySQL Forums :: MyISAM :: ERROR 1117 "too many columns" in create stmt
Re: ERROR 1117 "too many columns" in create stmt
Date: August 22, 2005 06:39AM
I got the table description from Stefan, debugged the table creation procedure and found a limit for the table description size in the .frm file of 64KB.
His table has quite long column names besides their vast number.
The theoretical limit of the number of columns should be 4096.
His table has quite long column names besides their vast number.
The theoretical limit of the number of columns should be 4096.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| ERROR 1117 "too many columns" in create stmt | 4557 | 08/17/2005 06:26AM | |
| Re: ERROR 1117 "too many columns" in create stmt | 3421 | 08/22/2005 06:39AM | |
| Re: ERROR 1117 "too many columns" in create stmt | 3486 | Shane Bester | 07/07/2007 07:57AM |
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.
© 2013, Oracle Corporation and/or its affiliates