Re: trick to remember sort order?

[Ligaya Turmelle]

I'm not sure I understand what your asking.  Order by can be used for 
asc or desc (http://dev.mysql.com/doc/mysql/en/Sorting_rows.html).  If 
you are looking to update a column in a specific order then you are 
using the correct syntax(http://dev.mysql.com/doc/mysql/en/UPDATE.html).

I hope those links help you because I do not understand your question.
Respectfully,
Ligaya Turmelle
---
Life is a game... so have fun.
---
www.PHPCommunity.org
Open Source, Open Community
Visit for more information or to join the movement
Dave Dyer wrote:
Is there a trick to remember the sort order?  I want
to update some field to be the ordinal of the record according
to some sort criteria.
        update record set ordinal=CURRENT_ROW() order by xx


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]