It could be a known issue, but thought it's a well known well used feature
so, asking you all.
I am trying to create an index with the following command -
create index an_idx on atable
(acol desc, bcol, ccol)
/
Then when I do a -
show index from atable
It shows for all indexed columns the 'Collation' is 'A'. And also when we do a
query without any ORDER BY, the result is not sorted in descending order on
acol. For example a query like
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 ?
I am using MySQL version 5.0.3.
Thanks in advance.
People are conversing... without posting their email or filling up their mail
box. ~~1123626929418~~
roomity.com http://roomity.com/launch.jsp No sign up to read or search this
Rich Internet App
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
