MySQL Basics In Pictures
  1. Type:

    SELECT id, first, last FROM name ORDER BY id;

    then press ENTER.

    The window should look like this:

    In this query, ORDER BY id places the records in numeric order, based on their id numbers.

    TIP: To arrange records in reverse numeric or reverse alphabetical order, add DESC on the end. For instance, type:

    SELECT first, last FROM name ORDER BY last DESC;

    The DESC option refers to the word "descending." It tells MySQL to order things descending from high to low instead of the default: low to high.