MySQL: Visual QuickStart Guide (1st 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 |
| 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 06, 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 05, 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 |
| 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:
Newsletter #29 Sent!
The latest newsletter went out today. If you are not subscribed to receive it, you can read it online.(June 24, 2010)
Newsletter #28 Sent!
The latest newsletter went out today. If you are not subscribed to receive it, you can read it online.(May 29, 2010)
Newsletter #27 Sent!
The latest newsletter went out today. If you’re not subscribed to receive it, you can read it online.(April 24, 2010)
