Database Reference
In-Depth Information
Summary
The
SELECT
statement offers quite a number of parameters and possibilities that I had to
skip to keep this chapter from becoming too lengthy and too advanced for a learning book.
For instance, there are several options for caching results and a clause for exporting a res-
ults set to a text file. You can learn about these from other sources if you need them.
At this point, make sure you're comfortable with the
SELECT
statement and its main com-
ponents: choosing columns and using field aliases; choosing multiple tables in the
FROM
clause; how to construct a
WHERE
clause, including the basics of regular expressions; using
the
ORDER BY
and the
GROUP BY
clauses; and limiting results with the
LIMIT
clause. It
will take time and practice to become very comfortable with all of these components. Be-
fore moving on to
Chapter8
, make sure to complete the exercises in the next section.