If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Your Opinion

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-15-07, 15:51
SirChick SirChick is offline
Registered User
 
Join Date: Jun 2007
Posts: 1
Your Opinion

Im creating a website which is a online text based game... i was wondering what is more logical out of these options:

should i create a table for example to do with user's info like:
A) All of it in one table
or
B)Registration details under one table
Game exp under another
stats under another etc

Which one is most smartest to do and is there any down sides to doing one or the other from those options.. ive never done it before so wanted to know from people who may have tried both ...
Reply With Quote
  #2 (permalink)  
Old 06-15-07, 20:05
guelphdad guelphdad is offline
Registered User
 
Join Date: Mar 2004
Posts: 440
multiple tables depending on data. search on normalization.
Reply With Quote
  #3 (permalink)  
Old 06-16-07, 14:18
gvee gvee is offline
www.gvee.co.uk
 
Join Date: Jan 2007
Location: UK
Posts: 10,156
http://r937.com/relational.html courtesy of r937 who is a frequent user of these forums.
__________________
George
Twitter | Blog
Reply With Quote
  #4 (permalink)  
Old 06-16-07, 14:31
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,534
courtesy of paul litwin, who wrote the article and gave me permission to post it on my site
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #5 (permalink)  
Old 06-18-07, 03:40
aschk aschk is offline
Registered User
 
Join Date: Mar 2007
Location: 636f6d7075746572
Posts: 770
Have a look at E-R (entity relationship) diagrams. You will find they help to visualise the normalisation work you are doing.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On