MySQL Forums
Forum List  »  Newbie

databases vs tables
Posted by: david sobey
Date: August 23, 2004 03:47PM

hi

just a few questions:
1. apparently MySQLAdmin is used to create, delete databases, stuff
like that. But this can all be done through MySQL, ie just the normal
MySQL -u user -p etc etc. So what's the point of it?

2. I'm creating a website with a basic discussion forum. I'll also
have a member sign up and login system. The website, however, will
ultimately be used for discussion forums, project lists, membership
info etc for a club. Should i store the member info such as login and
password, age etc in a new table or new database. What are the general
rules regarding when to create a new table vs database. If i use a new
table, how do i create some organisation to seperate discussion posts
from project posts or news posts, other than using unique table names
like "DiscussionPosts" and "ProjectPosts". Ie how do i create some
sorta heirachy maybe?

3. To access the database to post discussion topics etc, users should
have a login and password. Should each user have their own entry in
MySQL.user database table or should i just create an Admin and
LimitedUser account in the MySQL.user database?

cheers
dave

Options: ReplyQuote


Subject
Written By
Posted
databases vs tables
August 23, 2004 03:47PM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.