MySQL Pocket Reference
by George Reese

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 4, 2005.

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:


(18) 2nd to last line;
"of to"
should be:
"of 0 to"


(23) last line;
1970-2069.The default...
should be:
1970-2069. The default...


(27) decimal, line 3, 
bad line break


(30), line 15, 
Fix the second single quote mark.


(37) REFRENCES section;
REFERENCEStable...
should be:
REFERENCES table...


(41) line 6;
resultss  should be results


(56) line 6;
DISTINCT | | DISTINCTROWS
should be:
DISTINCT | DISTINCTROWS


(57) "Aliases" 5th line;
are not be
should be:
have not been


(58), "Table1, Table2, Table3, ..." line 5; 
) Only
should be:
). Only


(61) line -4; 
Start with '#', not 'S'


(70) AVG;
bad line break splitting "e.g."


(71) STD; 
Use of '/' looks like division.  Instead use ' | '


(71) ADDDATE;
Remove second and third commas.


(72) BIN;
In the text, make "decimal" italic.


(74) DATE_ADD;
Remove second and third commas.


(75) DATE_SUB;
Add spaces between the words in the second parameter.


(83) RIGHT, 
The definition is wrong.  SUBSTRING, as defined on p.85,  starts counting from the left, not right.


(84) RTRIM;
Correct the back tick to use typewriter font.


(85) SUBSTRING, 
The example for the fourth function should be with the second function.