I'm learning more about SQL all the time--I'm new to
things now but I'm trying to read. I now realize
the importance of normalizing my data, but what I
can't figure out is what the easy way is of getting it
done
now that I already have a database set up.
Suppose I have a table "books", consisting of "id",
"title", and "publisher"; the "publisher" is
redundant. I'd like to create a "publisher" table
consisting of "id" and "publisher", and then I want my
original "books" table to use its "publisher" column
to hold the value of "publisher.id" instead of the
publisher's name.
Is there a way I can do this with an existing table
full of data, other than going through it line-by-line
with
a scripting language?
Thanks!
Jen
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
