Even if you normalize your database design, you must still tell it who owns
the row.  For example, you have a table containing the following columns:
    id     name

You have another table that contains the phone numbers:
    id    name    phone number

In order to connect the rows via a foreign key, you must have the
information in the first table and again in the second table.  Normalization
only seperates repetative data.  If you didn't normalize, your first table
would look something like this:
    id    name    phone number 1    phone number 2    phone number 3 (etc,
etc, etc).

Peter J. Krawetzky
-----Original Message-----
From: Cal Evans <[EMAIL PROTECTED]>
To: Kevin Connolly <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Tuesday, March 27, 2001 12:26 PM
Subject: RE: [PHP-DB] Multiple rows for one column in a MySQL table?


>No. You need to look at normalizing your database if you have this
>situation.
>
>Cal
>http://www.calevans.com
>
>
>-----Original Message-----
>From: Kevin Connolly [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, March 27, 2001 10:48 AM
>To: [EMAIL PROTECTED]
>Subject: [PHP-DB] Multiple rows for one column in a MySQL table?
>
>
>Hi,
>Is it possible to have multiple rows for one column of a MySQL databes? and
>if so how would I insert another row into the column in question?
>
>eg:
>
>id        Name        Phone Number
>1        Kev           123123
>
>2        John          234234
>                          345345
>
>3       Paul           789789
>
>Thanks,
>Kev.
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to