esestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Michael Knauf/Niles" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 14, 2003 6:01 PM
Subject: Populating one table with data from another
&
t; <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 14, 2003 7:01 PM
Subject: Populating one table with data from another
>
> Ok, this has got to be easy, but I'm not getting it right...
>
>
> I have a table, products containing a 944 rows. One of th
Ok, this has got to be easy, but I'm not getting it right...
I have a table, products containing a 944 rows. One of the fields is
fgNumber,
I have another table, categoryRelatedToProducts which also has an fgNumber
field and currently has no data.
I'd like to add all 944 fgNumbers to the categ
Use INSERT...SELECT syntax:
http://www.mysql.com/doc/en/INSERT_SELECT.html
-steve
At 12:01 PM -0500 1/14/03, Michael Knauf/Niles wrote:
Ok, this has got to be easy, but I'm not getting it right...
I have a table, products containing a 944 rows. One of the fields is
fgNumber,
I have another
At 12:01 -0500 1/14/03, Michael Knauf/Niles wrote:
Ok, this has got to be easy, but I'm not getting it right...
I have a table, products containing a 944 rows. One of the fields is
fgNumber,
I have another table, categoryRelatedToProducts which also has an fgNumber
field and currently has no da