Database Reference
In-Depth Information
point, we've used simple statements because the focus is on the APIs rather than on SQL.
The next chapter focuses on SQL instead, to show how to ask the database server more
complex questions.
Before you proceed, it's a good idea to reset the
profile
table used in this chapter to a
known state. Change location into the
tables
directory of the
recipes
distribution, and
run these commands:
%
mysql cookbook < profile.sql
%
mysql cookbook < profile2.sql
Several statements in later chapters use the
profile
table; by reinitializing it, you'll get
the same results displayed in those chapters when you run the statements shown there.