* Dan Jones
[...]
> This leads me to another question. What's the standard way of handling
> something like the author of a book when you have a collaboration or an
> anthology with multiple authors?
Normalizing.
> The only way I can think of to handle it is to have a sentinel value
> that indic
MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Saturday, August 09, 2003 12:57 AM
Subject: Updating table based upon matching field in second table
> I have a database of books that was originally created as a flat file.
> Each record has a number of fields, including the authors na
On Fri, 2003-08-08 at 21:14, Matthew McNicol wrote:
> > I have a database of books that was originally created as a flat file.
> > Each record has a number of fields, including the authors name. I'm
> > trying to convert the database to something a little more efficient.
> > I've created a new t
I have a database of books that was originally created as a flat file.
Each record has a number of fields, including the authors name. I'm
trying to convert the database to something a little more efficient.
I've created a new table (called Authors) of unique authors names and
assigned each one
