specializing in digital media technologies

Unfortunately, despite the best efforts of myself, the technical editor, the copy editor, and the line editor, despite the multiple revisions, errors still occur. This page lists all the errors found in the book.

Note: errors are corrected in subsequent printings and therefore your particular copy may not contain all of the following.

You may also find the solution to your problem by using the book's corresponding forum. Signficant changes in the technology will be addressed there and you can also find problems and solutions encountered by other readers.

Known Errors in the Book:

Chapter	Page #	Description	Date Added
4: Creating a MySQL Database	73	In Table 4.2, the description of the second item, VARCHAR, erroneously says that it's a fixed-length field. That should read a "variable-length" field.	August 30, 2007
5: Basic SQL	106	The "clients" table definition (see page 95) sets all the client address information as NOT NULL. Therefore, the INSERT commands on page 106 will not work as written. Either change the table definition or add address values to the INSERT queries.	August 30, 2007
5: Basic SQL	110	The INSERT queries in Step 4 erroneously quote numeric values. The queries still work but numbers don't need to be quoted.	July 09, 2008
5: Basic SQL	115	In Step 2, the query should be SELECT * FROM clients WHERE contact_last_name LIKE 'Doe'\G.	November 14, 2006
6: MySQL Functions	135	The caption to Figure 6.3 should say that the second through fourth characters are returned.	July 09, 2008
6: MySQL Functions	148	In the first paragraph, it says that the conditional limits results to the previous six months. This should say to the previous two months.	January 23, 2007
7: MySQL and PHP	174	The very last line is missing the "L" in $num = mysqli_num_rows($query_result);	July 10, 2007
7: MySQL and PHP	177	The code in Step 3 refers to mysql_connect.inc.php. That should actually be mysqli_connect.inc.php. The code in the corresponding script (Script 7.3, line 17) is correct.	January 23, 2007
7: MySQL and PHP	194	In Script 7.6, on line 36, it should say if (@mysqli_affected_rows($dbc) == 1) {. This change also applies to Step 6 on page 196.	November 14, 2006
12: Techniques for Programming	367	In Step 6, the INSERT query should begin INSERT INTO films (director_id, title, year_released) VALUES.	June 20, 2006
Click here to view the errata in the order they were submitted. Click here to view the most recent errors first. Click here to view the errata by page number.

Submit an Error:

Please limit submitted errors to grammatical, factual, or technical problems found within the MySQL: Visual QuickStart Guide (2nd Edition) text itself. Please do not use this form for subjective suggestions or to ask questions. You will not necessarily receive a reply based upon any information submitted through this form! I may reply, depending upon the situation, but if you need a reply, do not use this form.

If you are experiencing problems getting something to work, please DO NOT use this form. Either use the forum for a faster reply or contact the author directly (although it could be a week or more before you see a reply).

Chapter	Introduction Chapter 1: Installing MySQL Chapter 2: Running MySQL Chapter 3: Database Design Chapter 4: Creating a MySQL Database Chapter 5: Basic SQL Chapter 6: MySQL Functions Chapter 7: MySQL and PHP Chapter 8: MySQL and Perl Chapter 9: MySQL and Java Chapter 10: Advanced SQL and MySQL Chapter 11: MySQL 5 Features Chapter 12: Techniques for Programming Chapter 13: MySQL Administration Appendix A: Troubleshooting Appendix B: SQL and MySQL References Appendix C: Resources
Page #
Book Error
Your Name
Your Email Address

Search This Book!

Newsletter #16 Sent

Newsletter #16 just went out today after a long delay. It's a bigger one but there's lots of good stuff in there. You can read it online at http://www.dmcinsights.com/newsletter.php if you're not subscribed to receive it via email.
(October 23, 2008)

Ruby: Visual QuickStart Guide Complete!

I'm very happy to announce that I've completed my Ruby: Visual QuickStart Guide. The book should be available in about three weeks or so (around early November 2008). The book turned out well, I think, and it should hopefully be a nice addition to the relatively small catalog of Ruby books that are available. In particular, I think that the Ruby on Rails chapter is really nice. I was able to develop a real-world example that demonstrates many aspects of the Rails framework. It also covers Rails 2.1, which has some significant changes from the 1.x version of Rails. More news about this book to come in future newsletters and on this site!
(October 7, 2008)

Newsletter #15 Released

Newsletter #15 went out in early August but I've been remiss in posting this update about it. It's relatively short, with most of the discussion on the business side of creating your own business. You can read it online at http://dmcinsights.com/newsletter.php. The next newsletter should go out in a few days.
(September 2, 2008)

more news...