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. _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
