Hello All:
I'm attempting to split tables and set up relationships
between tables importing from another (unnormalized) database
type.
So far I have extracted fields representing one-to-many
from one table and created a table with this description.
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| Country | char(255) | YES | | NULL | |
| Varietal | char(255) | YES | | NULL | |
| Producer | char(255) | YES | | NULL | |
| Vineyard | char(255) | YES | | NULL | |
| Year | char(50) | YES | | NULL | |
| Size | char(255) | YES | | NULL | |
| WINEID | int(10) unsigned | | PRI | NULL | auto_increment |
+----------+------------------+------+-----+---------+----------------+
And I have the original table (USA) into which I have added a WINEID field.
It still has the corresponding (Country,...,Size) fields.
Is there a way using MySQL in which I can assign the Value in WineData.WINEID
to each USA.WINEID where the (Country,...,Size) fields match?
That would get me off of the 0 normal status.
Pointers to documentation would be appreciated as well.
BTW: I know that there are problems with the field types and size above.
TIA
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
http://www.johnsons-web.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
