DESC index column

2008-05-21 Thread Bof
Hi all - Is there a good workaround for mysql's lack of 'DESC' functionality when creating an index? I'm looking at migrating an Oracle RAC database to mysql (InnoDB or Cluster - testing both at the moment), and the Oracle database uses a lot of multi-column indexes with some colums indexed in d

Re: DESC index column

2008-05-21 Thread Bof
an extra column and > populate that with > (1000 - A) and use it as an ASC index. > > Same can be done with dates. > > Not always applicable, but it works and is fairly > easy to implement. > > Phil > > On Tue, May 20, 2008 at 2:20 PM, Bof > <[EMAIL PROTEC