renwoshin Posted January 22, 2006 Share Posted January 22, 2006 hi, i'm trying to make a friend's list type thing for our users, but I'm not sure how I should represent it in a database. Here are the possibilities I thought of:1) make a table for every username and every row would be a friend2) make one table for all the usernames and add a column for each friend3) somehow make a table within a table (is this even possible?) with the inner table being the friends of the usernameWhat do you guys think would be the best representation for a "friend's list"? Quote Link to comment Share on other sites More sharing options...
renwoshin Posted January 22, 2006 Author Share Posted January 22, 2006 specificially, would it be inefficient to add a table for each user? Like, if we had 3000 tables for one database, will that be bad? Quote Link to comment Share on other sites More sharing options...
renwoshin Posted January 24, 2006 Author Share Posted January 24, 2006 so no one knows the maximum number of tables in a database? Quote Link to comment Share on other sites More sharing options...
fenway Posted January 24, 2006 Share Posted January 24, 2006 Don't do it that way -- I've posted a response to your question on [a href=\"http://www.mysqlfreaks.com/forums/index.php?showtopic=8962&hl=\" target=\"_blank\"]this MySQLFreaks.com thread[/a]. 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.