I see people using:

SELECT FROM table WHERE column = 'whatever' ORDER BY column ASC.

Is there a reason for using ASC at the end? ...Isn't ascending order assumed? I thought only DESC had to be specified.

    To sort in reverse order, add the DESC (descending) keyword to the name of the column in the ORDER BY clause that you are sorting by. The default is ascending order; this may be specified explicitly using the ASC keyword.

    MySQL Reference Manual (C) 2002 MySQL AB

    you may want to use ` instead of ' around field name in SQL

      Originally posted by Bunkermaster


      you may want to use ` instead of ' around field name in SQL

      So there really is no good reason for using ASC[?].

        The default is ascending order; this may be specified explicitly using the ASC keyword.

        Up to you really

          Write a Reply...