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 Quote Link to comment 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? Quote Link to comment 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 Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Barand Posted June 23, 2008 Share Posted June 23, 2008 That's a link from your sticky Quote Link to comment 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. Quote Link to comment 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.