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 LarryUllman.com 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.
Downloads
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. http://www.DMCinsights.com/php/hello.php) 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
mysql2_scripts.zip (33 KB, last modified 11/07/2007)
Is this a book almost like a continuation of the php6 and mysql5 book… or rather, what is the comparison of the level of teachings in the two books?
Hello Jason,
Thanks for your interest in the MySQL book. It’s kind of off to the side of the PHP & MySQL book. There is some overlapping content, but the MySQL book also discusses Perl and Java a bit, along with programming techniques such as storing and retrieving binary data. You’ll also learn more advanced concepts like regular expressions (in MySQL), user-defined variables, unions, stored procedures, triggers, and views. Then there’s more on installation, configuration, and administration. Hope that helps! Larry