MySQL Forums
Forum List  »  MyISAM

Re: ERROR 1117 "too many columns" in create stmt
Posted by: Ingo Strüwing
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.

Options: ReplyQuote

Written By
Re: ERROR 1117 "too many columns" in create stmt
August 22, 2005 06:39AM

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.