MySQL: Visual QuickStart Guide

Welcome to the companion Web pages for the first 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 first edition, published in September 2008 (ISBN 0-321-12731-5). The second edition was published in May 2008 (ISBN 0-321-37573-4). If you are using the second 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 FIRST 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 and SQL Commands

mysql_scripts.zip (33 KB, last modified 06/04/2007)

4 responses to MySQL: Visual QuickStart Guide

  1. what are the extra things this book have over php-6-and-mysql-5-for-dynamic-web-sites-visual-quickpro-guide-3rd-edition?
    thanks

    • Thanks for your question. For starters, this book talks about Java and MySQL and Perl and MySQL, which may or may not be useful to you. Largely it goes into everything in much more detail, though, from database design to storage engines and character sets to MySQL functions. The advanced stuff, specifically regular expressions, user-defined variables, unions, stored routines, triggers, and views, aren’t in the PHP and MySQL book at all. The same goes for storing and retrieving binary data, as well as all the MySQL administration stuff. It’s really just much more in-depth on MySQL.

  2. Hi, Larry, I am reading the book named as: PHP and MySQL for Dynmic Websites, 2nd edition, which was borrowed from the public liberary, and a little dameged on the bottom page, so I can’t find the information the file named as:the layout.css. Would you pleas help me and inform me with the information Where can I download the file layout.css because it is very important to me to do related exercises in your book.

Comments are great, but I'd strongly prefer any requests for assistance get made in the support forums. Thanks!