[thelist] mysql - null - returns results anyway

Phil Turmel pturmel-webdev at turmel.org
Wed Dec 23 09:33:48 CST 2009

On 12/22/2009 10:53 PM, r937 wrote:
>> ... I often find myself using these sorts of quick-and-dirty queries
>> as the basis for views, in which case the extra
>> "order by" is useful and appropriate. 
> ORDER BY is ~never~ appropriate for a view
> full stop
> ;o)

Hmmm.  Learn something new every day.  I'm now going to have to play
with query analyzers on the platforms I have at hand to see if the
optimization I thought mattered was a figment of my imagination.

Thanks for the tip.  Can you tell I'm an EE, not a CS grad?


More information about the thelist mailing list