I personally think Paul Dubois's book MySQL does a good
job not only covering all aspects of MySQL installation,
setup, and maintenance, but I think it also gives a very
good introduction on table design right in Chapter 1 (I have
the 1st MySQL - I see on Paul's homepage
On Wed, 18 Jun 2003 09:34:11 -0500, NIPP, SCOTT V (SBCSI) wrote:
Hi Scott
We're drifting off-topic, so I'll just give a schema below and then
fade away...
Let's say that I have users Mary, Joe, Frank, and Dan. I also
have
servers panther, cheetah, jaguar and lion. The data for each
insertion, but designing the layout and relationships of the tables is where
I am truly lost. Thanks again.
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 6:05 PM
To: DBI users
Subject: RE: Database layout and query questions...
On Tue, 17 Jun 2003 15
)
Subject: RE: Database layout and query questions...
Scott,
Define your details table to have a column that refers to the server.
e.g.
Table definition.
user_name char(20)
server_name char(60)
shell
etc.
etc.
Then you have everything in one table and you can pull out details
: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 10:11 AM
To: 'Ron Savage'; DBI users
Subject: RE: Database layout and query questions...
I have this book, however, it doesn't really have any good
information that I have found specifically regarding database
at it. Pity.
Table design is one of the few things I find easy. If you live in
Melbourne, Australia, drop in!
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 6:05 PM
To: DBI users
Subject: RE: Database layout and query questions...
On Tue, 17 Jun
Thanks again for all the good feedback. If anyone can recommend
a good book that could help me out on this I would be most
appreciative. I have some MySQL reference books, but nothing that
really goes into database design. I am planning on taking some
database courses at a local
I didn't
in the mean time.
-Original Message-
From: David N Murray [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 3:21 PM
To: NIPP, SCOTT V (SBCSI)
Cc: '[EMAIL PROTECTED]'
Subject: Re: Database layout and query questions...
Some questions, that might help you answer yours:
What's the advantage
On Tue, 17 Jun 2003 15:35:20 -0500, NIPP, SCOTT V (SBCSI) wrote:
Hi Scott
Thanks again for all the good feedback. If anyone can recommend
a
good book that could help me out on this I would be most
appreciative. I
have some MySQL reference books, but nothing that really goes into
database
Some questions, that might help you answer yours:
What's the advantage of having a table per user, vs. a 'users' table with
one row per user?
How many rows do you envision in each user table, and what are their
columns?
If you are looking to create a per_user table that just contains 'key',
10 matches
Mail list logo