List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:August 13 1999 5:38pm
Subject:Re: ERROR 1117: TOO MANY COLUMNS
View as plain text  
tianxuedong@stripped wrote:
> 
> 
> 
>     When I create a database table by using "load data infile....", It tells
> me that "error 1117 in line 1, too
> many columns". Can anybody tells me the reason. My table
> has about 2500 columns. Is there a limit for table columns
> mysql can handle?
>                           Xuedong

Hi Xuedong

Mmmh... I doubt you normalized your table design.

Anyway:
From  <http://www.mysql.com/crash-me-choose.htmy>:
3.22.10   Max columns in table = 2364
          Max length of row (without *BLOB and/or *TEXT) = 65534 Bytes

3.23.2    Max columns in table = 3398
          Max length of row (without *BLOB and/or *TEXT) = 65534 Bytes


Tschau
Christian

Thread
ERROR 1117: TOO MANY COLUMNStianxuedong13 Aug
  • Re: ERROR 1117: TOO MANY COLUMNSMartin Ramsch13 Aug
  • Re: ERROR 1117: TOO MANY COLUMNSChristian Mack13 Aug
Re: ERROR 1117: TOO MANY COLUMNStianxuedong13 Aug
  • Re: ERROR 1117: TOO MANY COLUMNSSteve Ruby13 Aug
  • Re: ERROR 1117: TOO MANY COLUMNSChristian Mack17 Aug