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? 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. 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. Link to comment https://forums.phpfreaks.com/topic/238780-maximum-database-columns/#findComment-1226995 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.