asdas wrote:
I am trying to create an index with the following command -
create index an_idx on atable
(acol desc, bcol, ccol)
/
select pk, acol, bcol, ccol from atable
doesn't show the result in descending order of acol, instead it's in ascending
order of acol.
Is there a simple trick I am missing ?
Note the last line of this excerpt from The Fine Manual :-)
<http://dev.mysql.com/doc/mysql/en/create-index.html>
An index_col_name specification can end with ASC or DESC. These keywords
are allowed for future extensions for specifying ascending or descending
index value storage. Currently they are parsed but ignored; index values
are always stored in ascending order.
HTH!
--
Hassan Schroeder ----------------------------- [EMAIL PROTECTED]
Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com
dream. code.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]