From: Your Name (bg271828yahoo.com)
Date: Fri Jul 02 2004 - 22:40:23 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]