jacobcunningham Posted June 8, 2011 Share Posted June 8, 2011 Is there a maximum number of columns that can be created when using the "CREATE TABLE" query? I don't want to get into specifics about the project, but I am reading from a file and based on the content of each line will determine its column name. The file I am parsing is about 1.6 million lines. I tested creating a table and columns with a few lines from the file and it works fine, but when I try to test about 15k lines it wont create the table. So basically I want to know is is there a limit that one query can handle? Should I break up this query into several "ALTER TABLE" queries for every X column names? Quote Link to comment https://forums.phpfreaks.com/topic/238780-maximum-database-columns/ Share on other sites More sharing options...
jcbones Posted June 8, 2011 Share Posted June 8, 2011 Are you saying that you want to create a table with 1.6 million columns? MySQL column limit explained. Quote Link to comment https://forums.phpfreaks.com/topic/238780-maximum-database-columns/#findComment-1226947 Share on other sites More sharing options...
PFMaBiSmAd Posted June 8, 2011 Share Posted June 8, 2011 Ummm. I reviewed your previous threads and short answer - you don't add columns to a DATEBASE table just because you add another contact/client/location/category of information to that table. That is spreadsheet thinking and results in horrible database designs. You add rows to a database table, one row for each piece of data. Quote Link to comment https://forums.phpfreaks.com/topic/238780-maximum-database-columns/#findComment-1226995 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.