* 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
you were close, try:-
update books, authors set books.AuthorID = authors.AuthorID where books.first_name =
authors.first_name and books.last_name = authors.last_name;
Notes
- you have loaded the existing flat file into a MySQL table called books.
- you mentioned that you have altered the b
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
