what was the error?
"dwalker"
<dwalker@healthyproduct To: <holmes072000@charter.net>, "'professional php'"
splus.com> <pro_php@p2p.wrox.com>, <php-db@lists.php.net>,
<php-general@lists.php.net>
10/19/2002 08:32 PM cc:
Please respond to Subject: Re: 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 <holmes072000@charter.net>
To: 'dwalker' <dwalker@healthyproductsplus.com>; 'professional php'
<pro_php@p2p.wrox.com>; php-db@lists.php.net <php-db@lists.php.net>;
php-general@lists.php.net <php-general@lists.php.net>
Date: Saturday, October 19, 2002 7:24 PM
Subject: RE: 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; php-db@lists.php.net; php-general@lists.php.net
>Subject: 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
