Chapter 6

1. The semicolon (;).
2. SELECT and FROM.
3. Since this selects all columns in a table, it is considered more expensive than if you specify the columns you need.
4. It helps to limit the results of your queries.
5. Percent (%) and underscore (_).
6. It helps you to sort your results.
7. ASC or DESC.
8. EXPLAIN.
9. Right-click a table and choose Alter Table or you can execute a SQL query to alter the table.
10. Click the Query menu in MySQL Workbench, then choose Explain Current Statement.