How to Copy Table1 to Table2 ?

[JC-Atl]

I have 2 tables in a database:

As an example, let's say Table1 has 20 rows, like this:

Table1:
CategoryNumber CategoryName
1000 Radios
1001 CD Players
.... ...
1019 Older Electronics

Let's say Table 2 has 12 rows, like this
Table2:
Column1 Column2 ProductCategory
0000001 Dan Old TVs
0000002 Steve Old Computers
.... ...
0000011 Debbie Old Guitars

How do I copy all rows of Table1 to Table2 in as few MySQL statements as
possible ?
In otherwords, without writing 20 separate SQL Insert statements ?

Also, the columns from Table1 go into Table2 as described below:
Table1.CategoryNumber ---> Table2.Column1
"Owners Unknown" ---> Table2.Column2
Table1.CategoryName ---> Table2.ProductCategory

Many thanks for your help and patience regarding this newbie question.
Sincerely,
jc

[Johan]

Hi,

You can use this format for insert
INSERT INTO tb2(fldID) SELECT tbl.fldOrder_ID FROM tbl WHERE tbl.fldOrder_ID

100;The where clause is optionalJohan

"JC-Atl" <Em***@WithHeld.net> schreef in bericht
news:xD*****************@bignews4.bellsouth.net... I have 2 tables in a database:

As an example, let's say Table1 has 20 rows, like this:

Table1:
CategoryNumber CategoryName
1000 Radios
1001 CD Players
... ...
1019 Older Electronics

Let's say Table 2 has 12 rows, like this
Table2:
Column1 Column2 ProductCategory
0000001 Dan Old TVs
0000002 Steve Old Computers
... ...
0000011 Debbie Old Guitars

How do I copy all rows of Table1 to Table2 in as few MySQL statements as
possible ?
In otherwords, without writing 20 separate SQL Insert statements ?

Also, the columns from Table1 go into Table2 as described below:
Table1.CategoryNumber ---> Table2.Column1
"Owners Unknown" ---> Table2.Column2
Table1.CategoryName ---> Table2.ProductCategory

Many thanks for your help and patience regarding this newbie question.
Sincerely,
jc

[Johan]

Hi,

You can use this format for insert
INSERT INTO tb2(fldID) SELECT tbl.fldOrder_ID FROM tbl WHERE tbl.fldOrder_ID

100;The where clause is optionalJohan

"JC-Atl" <Em***@WithHeld.net> schreef in bericht
news:xD*****************@bignews4.bellsouth.net... I have 2 tables in a database:

As an example, let's say Table1 has 20 rows, like this:

Table1:
CategoryNumber CategoryName
1000 Radios
1001 CD Players
... ...
1019 Older Electronics

Let's say Table 2 has 12 rows, like this
Table2:
Column1 Column2 ProductCategory
0000001 Dan Old TVs
0000002 Steve Old Computers
... ...
0000011 Debbie Old Guitars

How do I copy all rows of Table1 to Table2 in as few MySQL statements as
possible ?
In otherwords, without writing 20 separate SQL Insert statements ?

Also, the columns from Table1 go into Table2 as described below:
Table1.CategoryNumber ---> Table2.Column1
"Owners Unknown" ---> Table2.Column2
Table1.CategoryName ---> Table2.ProductCategory

Many thanks for your help and patience regarding this newbie question.
Sincerely,
jc

[Johan]

Hi,

You can use this format for insert
INSERT INTO tb2(fldID) SELECT tbl.fldOrder_ID FROM tbl WHERE tbl.fldOrder_ID

100;The where clause is optionalJohan

"JC-Atl" <Em***@WithHeld.net> schreef in bericht
news:xD*****************@bignews4.bellsouth.net... I have 2 tables in a database:

As an example, let's say Table1 has 20 rows, like this:

Table1:
CategoryNumber CategoryName
1000 Radios
1001 CD Players
... ...
1019 Older Electronics

Let's say Table 2 has 12 rows, like this
Table2:
Column1 Column2 ProductCategory
0000001 Dan Old TVs
0000002 Steve Old Computers
... ...
0000011 Debbie Old Guitars

How do I copy all rows of Table1 to Table2 in as few MySQL statements as
possible ?
In otherwords, without writing 20 separate SQL Insert statements ?

Also, the columns from Table1 go into Table2 as described below:
Table1.CategoryNumber ---> Table2.Column1
"Owners Unknown" ---> Table2.Column2
Table1.CategoryName ---> Table2.ProductCategory

Many thanks for your help and patience regarding this newbie question.
Sincerely,
jc