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 |
|---|---|---|---|
| 1: Installing MySQL | 11 | Figure 1.19 shows a slight different command than those in Step 11. Either sequence of commands will work (the one is just shorthand for the other). | September 23, 2003 |
| 2: Running MySQL | 21 | In step 2, it refers to mysqld-max-net which should be mysqld-max-nt. | April 20, 2003 |
| 2: Running MySQL | 21 | The last line in Step 4 is missing the slash in C:\WINNT. | April 6, 2004 |
| 2: Running MySQL | 34 | The GRANT statement demonstrated in Step 5 is no longer valid in MySQL. They have changed permissions so that FILE is only allowed for users, not for specific databases. Remove “, FILE” from the statement to correct this. | June 23, 2004 |
| 3: Database Design | 57 | There are two places in Table 3.6 where the table expenses is erroneously capitalized. | November 5, 2003 |
| 4: SQL | 80 | In the last tip, the SQL query is missing a closing single quotation mark. It should read SELECT invoice_id, invoice_amount, invoice_date FROM invoices WHERE invoice_date >= ‘2002-03-01’ ORDER BY invoice_date DESC. | February 20, 2003 |
| 5: MySQL Functions | 94 | Midway through the top paragraph, it should say I know that the area code is the second through fourth characters. | August 11, 2004 |
| 5: MySQL Functions | 102 | In the last line of the sidebar, it should read …to subtract 1 year… not …to add 1 year…. | September 26, 2003 |
| 6: MySQL and PHP | 116 | In Script 6.1 and in Step 3 on page 117, the define() function is used incorrectly. The constant name should be in single or double quotation marks, like so: DEFINE (“DB_USER”, “username”); This error is repeated in later PHP scripts as well. |
January 14, 2004 |
| 8: MySQL and Java | 187 | In Step 9, you should type java Connect not java Connect.java to run the application. | July 18, 2003 |
| 10: MySQL Administration | 239 | Embarassingly enough, the code example after the first full paragraph mistakenly uses < instead of the proper >. The following examples are correct, though. | April 19, 2004 |
| Appendix A: Troubleshooting | 282 | In step two, the code should be /bin/safe_mysqld –user=mysql –skip-grant-tables & (it’s missing the L in mysqld). |
October 22, 2002 |