|
|
 |
SQL I need advice about tables
sandwichs | Posted 8:37am 13. October 2002 Server Time |
hey guys...
I'm starting a new web site from scratch.
The info I'll need to gather will be:
Username, Password, email, Comments1, comments2 and blahblah3, etc...
so,...
scenario number 1: all these info go into one table.
scenarion number 2 : username and password go in one table and a new table is created for each user to put email, Comments1, comments2 and blahblah3, etc...
What is the best way to go?
I hope I made this understandable :)
Linda
|
Kodo | Posted 9:48am 13. October 2002 Server Time |
making a NEW TABLE for each person would not be in your best interest. make ONE user table with the required fields and INSERT each users info intot that table.
Follow scenario 1. Make an ID field(autonumber in access or identity in SQL server) to create a unique id for each user.
sandwichs | Posted 10:31am 13. October 2002 Server Time |
thanks.... I going to go that way then
Show all replies to 'SQL I need advice about tables'
|
This post have been closed for new replies
|
|
|
|
|
|
