MySQL Forums
Forum List  »  Newbie

Bulk data question
Posted by: Shaun Thomson
Date: December 29, 2011 10:01PM


I have a user site that has a basic user reg table - email, name etc with a unique ID number.

I now want to add a way for each user to store a catalog of their book collection. This catalog would contain the author and title of each book, in a way that they are linked to each other, but can be sorted by title or author.

As each user may have hundreds, maybe thousands of books, I was wondering what is the best way to set something like this up without having to create a new table for each user in which to store their library? Or is this the only way?

Thanks for your time and help.


Options: ReplyQuote

Written By
Bulk data question
December 29, 2011 10:01PM
December 31, 2011 10:12AM
January 01, 2012 06:01AM
January 02, 2012 09:10PM
January 04, 2012 09:38PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.