Re: [chiPHPug-discuss] syntax error

[Neil Y. <ny...@as...>]

Technically, that WHERE is in a SELECT subquery syntax, not the actual 
INSERT syntax.

Neil

Stephen Weinberg wrote:
> Side track since the question is answered, but you can use a where clause
> with insert if you want to select rows from another table (or group of
> tables) and add them to the new table that way.
>
> insert into table_2 (col1, col2, col3)
> select A. B, C
> from table_0 join table_1 on table_0.id = table_1.id
>
>
>
> Stephen
>
> On Thu, May 1, 2008 at 3:02 PM, Neil Rest <Nei...@rc...> wrote:
>
>   
>> Does INSERT take a WHERE?  A new row wouldn't be qualified by a WHERE
>> clause.
>> If you're updating a record, try UPDATE.
>>
>>
>> At 02:51 PM 5/1/2008, "Roderick Thomas" <tho...@ms...> wrote:
>>
>>     
>>> $query_LogRecordNum="INSERT INTO ChangeLog WHERE conuid='$conuid'
>>> AND changedate='$added_reportdate' SET recordnum='$added_recordnum'";
>>>       
>> Neil
>> --
>> Nei...@rc...
>>
>> If liberty means anything at all, it means the right to tell people
>> what they do not want to hear.
>>  -- George Orwell, 1945
>>
>>
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
>> Don't miss this year's exciting event. There's still time to save $100.
>> Use priority code J8TL2D2.
>>
>> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
>> _______________________________________________
>> chiPHPug-discuss mailing list
>> chi...@li...
>> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss
>>
>>     
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> Don't miss this year's exciting event. There's still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> chiPHPug-discuss mailing list
> chi...@li...
> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss
>