MySQL Cookbook, 2nd Edition

The MySQL Cookbook Companion Web Site

MySQL Cookbookhas a companion web site that you can visit to obtain the source code and sample data for examples developed throughout this book:

http://www.kitebird.com/mysql-cookbook/

The sample data and errata are also available at the O’Reilly web site listed in the “How to Contact Us” section.

The main software distribution is named recipes, and you’ll find many references to it throughout the book. You can use the distribution to save a lot of typing. For example, when you see a CREATE TABLE statement in the book that describes what a database table looks like, you’ll usually find an SQL batch file in the tables directory of the recipes distribution that you can use to create the table instead of entering the definition manually. Change location into the tables directory, and then execute the following command, where filename is the name of the file containing the CREATE TABLE statement:

%mysql cookbook < 
            filename

If you need to specify MySQL username or password options, put them before the database name.

For more information about the recipes distribution, see Appendix A.

The Kitebird site also makes some of the examples from the book available online so that you can try them from your browser.