|
While reading the MySQL manual for INSERT SELECT, I was
not able to determine how to include all 5 fields of one table into another
table (containing 100 fields) into SPECIFIC data fields. Do I need to
explicitly list all the fields within the table of 5 fields? If so, would
the statement be:
INSERT INTO Products
(ProductName,Size,SuggestedRetailPrice,ProductCategory,ManufacturerName)
SELECT(kalproduct.Product, kalproduct.size,
kalproduct.SRP, kalproduct.Cat, kalproduct.manname)
FROM kalproduct
;
Thanking you in advance.
P.S. I'd give it a try, but I'm trying to move 500
partial records into a table containing at least 2000 records -- didn't want to
start from scratch.
This email message and all attachments transmitted herewith
are trade
secret and/or confidential information intended only for the viewing and use of addressee. If the reader of this message is not the intended recipient, you are hereby notified that any review, use, communication, dissemination, distribution or copying of this communication is prohibited. If you have received this communication is error, please notify the sender immediately by telephone or electronic mail, and delete this message and all copies and backups thereof. Thank you for your cooperation.
|
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
