Re: [PHP-DB] MySQL Insert Select statement
what was the error? "dwalker" , "'professional php'" splus.com> <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> 10/19/2002 08:32 PM cc: Please respond to Subject: Re: [PHP-DB] MySQL Insert Select statement "dwalker" For some reason the Insert Select statement returned an ERROR and I had to resort to INSERT INTO Products (ProductName,Size,SuggestedRetailPrice,ProductCategory,ManufacturerName) SELECT * FROM kalproduct ; Is there a noticeable reason why: INSERT INTO Products (ProductName,Size,SuggestedRetailPrice,ProductCategory,ManufacturerName) SELECT(kalproduct.Product, kalproduct.size, kalproduct.SRP, kalproduct.Cat, kalproduct.manname) FROM kalproduct ; would have returned an error message?? I don't want to have to create multiple tables for the purpose of inserting into others. -Original Message- From: John W. Holmes <[EMAIL PROTECTED]> To: 'dwalker' <[EMAIL PROTECTED]>; 'professional php' <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Saturday, October 19, 2002 7:24 PM Subject: RE: [PHP-DB] MySQL Insert Select statement >That's how you do it. Hopefully you've figured it out already. > > > >---John Holmes. > > > >-Original Message- >From: dwalker [mailto:dwalker@;healthyproductsplus.com] >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: > > > >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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL Insert Select statement
For some reason the Insert Select statement returned an ERROR and I had to resort to INSERT INTO Products (ProductName,Size,SuggestedRetailPrice,ProductCategory,ManufacturerName) SELECT * FROM kalproduct ; Is there a noticeable reason why: INSERT INTO Products (ProductName,Size,SuggestedRetailPrice,ProductCategory,ManufacturerName) SELECT(kalproduct.Product, kalproduct.size, kalproduct.SRP, kalproduct.Cat, kalproduct.manname) FROM kalproduct ; would have returned an error message?? I don't want to have to create multiple tables for the purpose of inserting into others. -Original Message- From: John W. Holmes <[EMAIL PROTECTED]> To: 'dwalker' <[EMAIL PROTECTED]>; 'professional php' <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Saturday, October 19, 2002 7:24 PM Subject: RE: [PHP-DB] MySQL Insert Select statement >That's how you do it. Hopefully you've figured it out already. > > > >---John Holmes. > > > >-Original Message- >From: dwalker [mailto:dwalker@;healthyproductsplus.com] >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: > > > >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
RE: [PHP-DB] MySQL Insert Select statement
That's how you do it. Hopefully you've figured it out already. ---John Holmes. -Original Message- From: dwalker [mailto:dwalker@;healthyproductsplus.com] 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: 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.