MySQL Forums :: General :: Max columns per Table
Max columns per Table
Posted by: Kan Kumar ()
Date: September 29, 2006 11:40AM
Hi,
I am trying to create a table with more than 2000 columns, but its giving me the following error:
DBD::mysql::st execute failed: Too many columns at
I have done my research and found that MySQL database do supports up to 3398 columns per table.
Is there is any configuration file where I specify the max columns per table?
Thanks for your help in advance.
Kan Kumar
I am trying to create a table with more than 2000 columns, but its giving me the following error:
DBD::mysql::st execute failed: Too many columns at
I have done my research and found that MySQL database do supports up to 3398 columns per table.
Is there is any configuration file where I specify the max columns per table?
Thanks for your help in advance.
Kan Kumar
MySQL Forums :: General :: Max columns per Table
Re: Max columns per Table
Posted by: Pujitha Sendanayake ()
Date: August 15, 2007 06:47PM
Maximum columns per table in mySql
---------------------------------------------------------------------------
Practically,Maximum number of columns per table is 2599.
Following is the easiest way to deal with your issue (This is tested for mysql5.x on windows xp platform).
---------------------------------------------------------------------------
1)Download mysql administrator from http://www.mysql.org/downloads/gui-tools/5.0.html
2)Install it.
3)Create or access your database using mysql administrator
4)Using mysql administrator goto startup variable->general parameters->general
Under general group,untick checkbox called "default storage"
That is we allow sql-create statement to use the default type.
5)Restart mysql service
6)Try your sql statement now.But,as far as I know this works up to 2599 columns only.
---------------------------------------------------------------------------
Practically,Maximum number of columns per table is 2599.
Following is the easiest way to deal with your issue (This is tested for mysql5.x on windows xp platform).
---------------------------------------------------------------------------
1)Download mysql administrator from http://www.mysql.org/downloads/gui-tools/5.0.html
2)Install it.
3)Create or access your database using mysql administrator
4)Using mysql administrator goto startup variable->general parameters->general
Under general group,untick checkbox called "default storage"
That is we allow sql-create statement to use the default type.
5)Restart mysql service
6)Try your sql statement now.But,as far as I know this works up to 2599 columns only.