cujo Posted June 22, 2008 Share Posted June 22, 2008 Hi, I'm looking for a way to organize some data. There will be a fairly large number of data tables to be inserted into the database. Unfortunately, the number of rows and columns for these data tables will not be constant. I want to assign a unique id to each cell and store the data for that cell (maybe two separate tables for the id and the data?). I want to know if it's possible to insert tables of this sort into a MySQL table. The only thing I can think of is creating a very large table (the max amount of rows and columns I could expect). However I imagine this would be messy and inefficient. Or is it possible to create a new table in the db for each data table? This would be messy but more efficient. Is there a better way of doing this? Thanks in advance Link to comment https://forums.phpfreaks.com/topic/111371-inserting-data-tables-with-varying-numbers-of-rows-and-columns-into-a-table/ Share on other sites More sharing options...
cujo Posted June 22, 2008 Author Share Posted June 22, 2008 Does creating a separate database with all the tables seem like a good solution? Link to comment https://forums.phpfreaks.com/topic/111371-inserting-data-tables-with-varying-numbers-of-rows-and-columns-into-a-table/#findComment-571830 Share on other sites More sharing options...
Barand Posted June 22, 2008 Share Posted June 22, 2008 http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html Link to comment https://forums.phpfreaks.com/topic/111371-inserting-data-tables-with-varying-numbers-of-rows-and-columns-into-a-table/#findComment-571857 Share on other sites More sharing options...
fenway Posted June 23, 2008 Share Posted June 23, 2008 There are some excellent stickes on this topic, too. Link to comment https://forums.phpfreaks.com/topic/111371-inserting-data-tables-with-varying-numbers-of-rows-and-columns-into-a-table/#findComment-572414 Share on other sites More sharing options...
Barand Posted June 23, 2008 Share Posted June 23, 2008 That's a link from your sticky Link to comment https://forums.phpfreaks.com/topic/111371-inserting-data-tables-with-varying-numbers-of-rows-and-columns-into-a-table/#findComment-572467 Share on other sites More sharing options...
fenway Posted June 23, 2008 Share Posted June 23, 2008 That's a link from your sticky LOL -- oops. Link to comment https://forums.phpfreaks.com/topic/111371-inserting-data-tables-with-varying-numbers-of-rows-and-columns-into-a-table/#findComment-572523 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.