MySQL: Visual QuickStart Guide (2nd Edition)

Welcome to the companion Web pages for the second edition of the book MySQL: Visual QuickStart Guide, written by Larry Ullman and published by Peachpit Press. This page is specifically for the book’s second edition, published in May 2008 (ISBN 0-321-37573-4). The first edition was published in September 2002 (0-321-12731-5). If you are using the first edition of the book, you should go to that page.

Beside the couple of pages dedicated to this edition of this book, there’s plenty of other content on that you might be interested in. Use the “Post Categories” links above to browse by general topic.

You can download the code for the book using the link below. If you have any questions or problems, I’d recommend using the book’s corresponding support forum, where you’ll get the fastest answer.


Every script in the text is available here to be downloaded. Some things you should know:

  • Although these scripts are named or numbered as they are in the book, they do include any updates and changes as warranted by errors that were found after publication. Thus, if you are having problems with a particular script, download the most current version here or check the errata section.
  • The download also contains a file with all of the SQL commands from the book. DO NOT ATTEMPT TO RUN THIS FILE IN BATCH MODE! If you want to use the SQL commands, copy the appropriate ones from the text file and paste them into the mysql client, phpMyAdmin, or whatever.
  • The URLs as referenced in the book (e.g. are not available for execution online.
  • These are the scripts for the SECOND EDITION of the book. If you are using a different edition, click the appropriate link above to find the correct page.
  • These scripts have been formatted with line breaks that will work on most systems running most text editors. If you have difficulty opening a script, try:
    • adjusting the way your text editor treats text files
    • using a different text editor, if possible
    • posting a message to the online forum, asking for help

Complete Set of Scripts (33 KB, last modified 11/07/2007)