“MySQL: Visual QuickStart Guide (2nd Edition)” Errata

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

Note: errors are corrected in subsequent printings and therefore your particular copy may not contain all of the following. You may also be experiencing problems not caused by a mistake in the book. If so, you may find the solution to your problem by using the book’s corresponding forum. Significant 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:

Click on a column heading to sort the table by that column.

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 102 The last bullet point should say “The word NULL must not be quoted.” (“word”, not “world”). May 24, 2009
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 9, 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 9, 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
10: Advanced SQL and MySQL 299 In the explanation of the code under Step 3, the “at symbol” (also called the “at sign” or “asperand”) is mistakenly called an “ampersand”. October 26, 2009
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