Learning MySQL
by Seyed M.M. "Saied" Tahaghoghi, Hugh E. Williams

This errata page lists errors outstanding in the most recent printing.

If you have technical questions or error reports, you can send them to
booktech@oreilly.com.  Please specify the printing date of your copy.

This page was updated April 17, 2008.

Here's a key to the markup:
	[page-number]: serious technical mistake
	{page-number}: minor technical mistake
	<page-number>: important language/formatting problem
	(page-number): language change or minor formatting problem
	?page-number?: reader question or request for clarification



Confirmed errors:

(xi) “the staff is” should be “the staff are”


(xv), under "Using Code Examples": 
"Ttahaghoghi" 
should be
"Tahaghoghi"


[8] lines 3-4;
"won't spent" -> "won't spend"


(10) para 2, last sentence;
Insert “to work together” after “Perl”


{19} “filename” should be “myfile.txt” in examples.


{22} bullet 2;
Version is now 5.0.26


(23) last sentence;
Insert “box” after “dialog”


(25) note;
 “i386” should be “i686”


(26) Second paragraph under “Installing MySQL on Linux using RPM Packages”;
Add “Packages with higher CPU numbers, such as i586 or i686, are better tuned for newer machines, but won’t work on older machines.


(61) Under “Installing Under Mac OS X”;
 “noninstallation” should be “non-installation” in the second bullet point.


(75) Change “password” to “mypass” in examples. 


{76} In the third line of code, there shouldn’t be quotes in the user input.


(79) para 4;
“Hold down” should be “press”.


(80) Under “Server Doesn’t Stop,” insert “and the password, if any,” after “username”.
	Insert “—password-che-root.password” after “user-root” in example.


(85) Insert “file” after “script” in the second sentence under “Stopping and Starting Apache”


(87) Under “Setting Up Perl”;
 “nontrivial” should be “complex.”


(97) Align “>” throughout.


(98) In the first sentence under “The Monitor Help,”;
Take “HELP” out of user-input font throughout the chapter, such as on p. 100.


(102) Change “password” to “mypass” in examples.


(103) Check font size for “the_username”.


(104) Bring “use” in the first sentence into consistency with the rest of the book—either make it all caps or not. Also, the author says that “the_mysql_ root_password” and the following example are not supposed to be italicezed.


(109) Change “his” to “their” before table.


(110) Align the first letter of the course name in the tables throughout.


(116) Move “m” to the customer vertex.
	

(118): Figure 4-5, 
"Appplications" 
should be 
"Applications"


(121) Move fig 4-10 to this page.


(122): change the literal tags in the last paragraph as follows:
        "artist" to "Artist"
        "album" to "Album"
        "track" to "Track"
        "played" to "Played"


{123} Capitalize the first letters of entity names.


(127) 2nd to last paragraph;
Change “trips” to “legs” in the first sentence.


(145) middle of page;
“a percentage character” should be “the percentage character.”


(146) Align “>” throughout.


{149} the query examples should include parentheses as below;

mysql> SELECT * FROM album WHERE album_id > 2
-> AND (NOT album_id) = 4 OR album_id = 6;
...
mysql> SELECT * FROM album WHERE (NOT album_id) = 4;
...
mysql> SELECT * FROM album WHERE (NOT album_id) != 4;


(154) “binary” should be all caps in example.


{156} In the last sentence before “Joining Two Tables” section, reverse “10” and “5”.


(163) middle of page;
“auto_increment” should be all caps.


(165) second-to-last paragraph;
“whose” should be “for which the”.


(168) Under "The DELETE STATEMENT';
“multitable” should be “multi-table”


(173) Check font on the_mysql_root_password”. Also on 331.


(182) Remove “temporarily” from the end of the first paragraph.


(182) “default” should be all-caps in examples.


(183)  4th line from the bottom;
than should be that


(187) Delete “instead” from the “creating temporary tables” section.


(192) Remove the excess characters in the first ASCII table.


(197) “From” should be capitalized.


(197) Make the blank-quote examples one and four spaces for clarity.


(203) Check example beginning with “SET” for spacing, font.


(205) Remove the excess space in the example at the end of the page.


(213) iddle of page;
“despite the file” should be “despite the files”.


(239) top of page;
Check font for “6 x 13”.


(248) Spacing is off in top table.


(252) first sentence;
Remove parentheses from sentence.


(268 and 269) Align the plus signs in the tables with the lines beneath. Also do this on 296, 325, 388, 390, 391.

(284)top of page;
Remove ‘ from around ':'.


(284) bottom of page;
Make “c:\” uppercase.


(302) Check font on “the_password”


{320} First paragraph, line 3;
...of access the user partmusic has for the database ResearchPeople.
should be:
...of access the user partmusic has for the database music.


(331) Check font on the_mysql_root_password”. 


(349) “set password” and “password” should be uppercase in examples.


(358) “set-charset” shouldn't be italicized.


(363) top of page;
Check font for “crontab -1.”


(390) “status” should be in user input font.


(391) Fragment in last sentence should be set off by em-dashes, not parentheses.


{475} Move the second line of the last example up to the first line.


“About the Authors”: Change “England” to “Britain” and “between civilizations” to “among civilizations.”