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
>acco
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
http://www.dubois.ws/pe
>>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 did
- that's why I suggested you have a look 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 use
-Original Message-
> From: 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
NIPP, SCOTT V (SBCSI)
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
data
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 20
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
>databa
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 t
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',
'value
10 matches
Mail list logo