[thelist] mysql - null - returns results anyway

John Townsend jft at worrigee.net
Wed Dec 23 04:54:10 CST 2009

>  From: r937 <rudy at r937.com>
>  Subject: Re: [thelist] mysql - null - returns results anyway
>  Sent: 23 Dec '09 14:53
>  <...munch...>  
>  ORDER BY is ~never~ appropriate for a view
>  full stop
>  ;o)

No, that's not the case.
MySQL allows for an ORDER BY in the definition of a view.
It is also smart enough to ignore that ORDER BY statement if the select statement you write
against the view has its own ORDER BY statement.
See http://dev.mysql.com/doc/refman/5.0/en/create-view.html    
Quite some way down the page is the quote:
"ORDER BY is allowed in a view definition, but it is ignored if you select from a view using a statement that has its own ORDER BY."
John Townsend

More information about the thelist mailing list