[RDD] Generic non-Rivendell MySQL question

Chris Howard - CBR cbr at elfpen.com
Tue Jan 28 15:16:20 EST 2014


On 1/28/2014 1:56 PM, Cowboy wrote:
> On Tuesday 28 January 2014 10:46:41 am Mike Carroll wrote:
>> How about using the INSERT statement with a SELECT subclause?
>> http://dev.mysql.com/doc/refman/5.6/en/insert.html
>>
> 
>  I can't even begin to tell you how many days I've spent
>  on mysql.com to come away with an incomplete understanding
>  that doesn't work for whatever reasons.
>  :(
> 

SQL is not procedural.
It is all about result sets.
So don't think of it like a loop or something.

Every statement but INSERT has to have a WHERE clause
attached to it in order to limit the rows being changed
or the rows being selected.  The WHERE clause is the filter
and the crux of it.




More information about the Rivendell-dev mailing list