What was the error?

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "dwalker" <dwalker@h...>
To: "professional php" <pro_php@p...>
Sent: Saturday, October 19, 2002 8:32 PM
Subject: [pro_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.