MySQL Cookbook, 2nd Edition

Conclusion and Words of Advice

This chapter discusses the basic operations provided by each of our APIs for handling various aspects of interaction with the MySQL server. These operations enable you to write programs that issue any kind of statement and retrieve the results. Up to this 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 would be a good idea to reset the profile table used in this chapter to a known state. Several statements in later chapters use this table; by reinitializing it, you’ll get the same results displayed in those chapters when you run the statements shown there. To reset the table, change location into the tables directory of the recipes distribution, and run the following commands:

%mysql cookbook < profile.sql
% mysql cookbook < profile2.sql