Conclusion and Words of Advice
This chapter discusses the basic operations provided by each of our APIs for handling various aspects of interacting with the MySQL server. These operations allow you to write programs that issue any kind of query and retrieve the results. Up to this point, we’ve used simple queries 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 queries in later
chapters use this table; by reinitializing it,
you’ll get the same results displayed in those
chapters when you run the queries 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
Get MySQL Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.