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
