Jump to content
Larry Ullman's Book Forums

Using Asc In Index For Tables In Yii_Cms Build Chapter


saniko
 Share

Recommended Posts

Larry,

 

I've noticed you use sort order (ASC) when building indexes for your tables.  I didn't think MySQL actually used this information at all because it can only do ASC indexes.  

 

Is that correct?

 

Love the book.  Can't wait to grab your new eCommerce book soon too!

 

Take care,

-saniko

  • Upvote 1
Link to comment
Share on other sites

You can do both ASC and DESC according to the mysql manual.

 

http://dev.mysql.com/doc/refman/5.5/en/create-index.html

 

Ah well may be not :wacko:

 

An index_col_name specification can end with ASC or DESC. These keywords are permitted 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.

Link to comment
Share on other sites

 Share

×
×
  • Create New...