our approach|new tutorials|contact us

MySQL Basics In Pictures

• Starting
• Administration
• Tables
• Queries
• Security
• Web

2. Type:
   SELECT first, last FROM name ORDER BY last;
   then press ENTER.
   The window should look like this:

   

   This query is more precise than the previous one: it selects the fields first and last from the table name.
   ORDER BY puts the records in alphabetical order, based on the field last. In other words, it puts the presidents' last names in alphabetical order.