saniko Posted November 5, 2013 Share Posted November 5, 2013 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 1 Link to comment Share on other sites More sharing options...
Edward Posted November 5, 2013 Share Posted November 5, 2013 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 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 More sharing options...
Recommended Posts