“MySQL: Visual QuickStart Guide” 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
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