That's how you do it. Hopefully you've figured it out already. 


---John Holmes.


-----Original Message-----
From: dwalker [mailto:dwalker@;] 
Sent: Saturday, October 19, 2002 7:51 PM
To: professional php; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Insert Select statement


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:



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











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.

Reply via email to