MySQL Forums
Forum List  »  Other Migration

N1NF to 1NF table conversion
Posted by: Altaz Belim
Date: July 06, 2009 03:51AM

I am migrating some data from EXCEL to MySQL, which include tables of the following form:

Person | Favorite Colors
-------- --------------------
Bob | blue, red
Jane | green, yellow, red

Which is a design that does not comply with 1NF. A more semantically correct design would be:

Person | Favorite Color
-------- --------------------
Bob | blue
Bob | red
Jane | green,
Jane | yellow
Jane | red

The real file is more complicated, with over 900 entries, making the conversion tedious. What can you suggest as a scripted solution to my problem?



Edited 1 time(s). Last edit at 07/06/2009 06:06AM by Altaz Belim.

Options: ReplyQuote


Subject
Views
Written By
Posted
N1NF to 1NF table conversion
5610
July 06, 2009 03:51AM
2894
July 06, 2009 08:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.