469,951 Members | 2,338 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,951 developers. It's quick & easy.

Canot make Index Descending ?

Whatever I try I do not seem to be able to get the keys to be Descending. I
assume collation A means Ascending which indeed they are when I enter DATA ?
I use

CREATE TABLE WGSubCategory (
CATId decimal(3,0) default 0,
SUCId decimal(3,0) default 0,
SUCDescription char(30) default NULL,
CATActive decimal(1,0) default 1,
UNIQUE KEY WGSubCategoryI (CATId DESC, SUCId DESC)
) TYPE=MyISAM;
mysql> show index from WGSubCategory;
+---------------+------------+----------------+--------------+-------------+
-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+---------------+------------+----------------+--------------+-------------+
-----------+-------------+----------+--------+------+------------+---------+
| WGSubCategory | 0 | WGSubCategoryI | 1 | CATId |
A | NULL | NULL | NULL | YES | BTREE | |
| WGSubCategory | 0 | WGSubCategoryI | 2 | SUCId |
A | NULL | NULL | NULL | YES | BTREE | |
+---------------+------------+----------------+--------------+-------------+
-----------+-------------+----------+--------+------+------------+---------+

Collation is A regardless of DESC in the index table creation

Help please.

Gary
Jul 19 '05 #1
2 1514
Gary wrote:
Whatever I try I do not seem to be able to get the keys to be Descending.


What does that have to do with Perl?

If you have an SQL problem, go post it to an SQL newsgroup.
If you have a Perl problem, go post it to comp.lang.perl.misc instead of here.
-Joe
Jul 19 '05 #2

"Joe Smith" <Jo*******@inwap.com> wrote in message
news:q0I7c.59576$JL2.765032@attbi_s03...
Gary wrote:
Whatever I try I do not seem to be able to get the keys to be
Descending.
What does that have to do with Perl?

If you have an SQL problem, go post it to an SQL newsgroup.
If you have a Perl problem, go post it to comp.lang.perl.misc instead of here. -Joe

Good point

Thanks.
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Luigi Napolitano | last post: by
2 posts views Thread by Trevor Best | last post: by
3 posts views Thread by charley | last post: by
2 posts views Thread by MissiMaths | last post: by
10 posts views Thread by Laurence | last post: by
9 posts views Thread by fgh.vbn.rty | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.