MySQL: Visual QuickStart Guide (2nd Edition)-->Errata
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 | 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 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 |
| 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 |
| 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:
Search This Book!
Newsletter #25 Sent!
The latest newsletter went out today. If you're not subscribed to receive it, you can read it online.(February 2, 2010)
Newsletter #24 Released
The latest newsletter went out today. If you're not subscribed to receive it, you can read it online.(December 17, 2009)
New Blog Series on the Yii Framework
I've been writing a series of articles on the Yii framework for PHP Web development. There are currently seven posts, taking you from start to finish of the development process, with more to come.(November 12, 2009)
