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 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)

7 responses to MySQL: Visual QuickStart Guide (2nd Edition)

  1. 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

  2. I love your books. I think that you have a flair for writing. I am glad that it is your book that I have encountered. I thought that PHP had been too difficult for me. Your book is really good.

    Your fan

  3. My apologies for the huge slab of ‘moron’ about to be hurled your way in the form of a question…
    (also further apologies for CAPS for emphasis)

    Um…On page 107 of the MySQL book you instruct us to continue populating the two tables with data. But WHAT data? I presume that immanently we’re going to be doing exercises where the only way to verify whether we’ve performed the query right is to compare our return to yours. But in that case we’d need the same data. Now wait, I’m not a COMPLETE moron, as I understand that you go on to say (paraphrased) “if you don’t use the downloads I provide on my site your results MAY differ”… But the ‘may’ there is really confusing. It makes it sound like cutting and pasting your commands from the download are the only way to ‘completely’ ensure fidelity, but that we may nonetheless get it right merely by manually entering the data ourselves. Which brings me back to… what data? I flipped back a few pages, didn’t see any more data for population purposes. Even here on the web site, I only see a zip file that has folders for chapters 7, 8, 9, 12. But I’m back here in chapter 5, unsure of how to proceed.

    Also, as a side note, in your examples of to alternative methods of populating rows, you seem to continually say to try one method “or” the other. But then, do you not want us to enter all that example data? And then my previous question comes up here too: Is whether or not we do so going to affect whether our queries come back correctly later in the book? Are you expecting that ‘all’ the data in your (seemingly) disjunctive examples has been fed into the database. I’m tempted to say ‘yes’, but that’s just because that’s ALL the data I can presently find to populate with!

    Sorry for the length here.

    -a moron

Trackbacks and Pingbacks:

  1. What is Larry Thinking? #42 => Doing What I Do, Part 3 – Larry Ullman - July 4, 2011

    [...] (other examples include VIEWs and UNIONs). I previously wrote about stored procedures in my “MySQL: Visual QuickStart Guide” and my “PHP 5 Advanced: Visual QuickPro Guide“, and then relied upon them [...]

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