MySQL Pocket Reference

Errata for MySQL Pocket Reference

Submit your own errata for this product.


The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update



Version Location Description Submitted By Date Submitted Date Corrected
Printed
Page 18
2nd to last line

"of to" should be: "of 0 to"

Anonymous   
Printed
Page 18
2nd to last line

"of to" should be: "of 0 to"

Anonymous   
Printed
Page 23
last line

1970-2069.The default... should be: 1970-2069. The default...

Anonymous   
Printed
Page 23
last line

1970-2069.The default... should be: 1970-2069. The default...

Anonymous   
Printed
Page 27
decimal, line 3,

bad line break

Anonymous   
Printed
Page 27
decimal, line 3,

bad line break

Anonymous   
Printed
Page 30
line 15,

Fix the second single quote mark.

Anonymous   
Printed
Page 30
line 15,

Fix the second single quote mark.

Anonymous   
Printed
Page 37
REFRENCES section

REFERENCEStable... should be: REFERENCES table...

Anonymous   
Printed
Page 37
REFRENCES section

REFERENCEStable... should be: REFERENCES table...

Anonymous   
Printed
Page 41
line 6

resultss should be results

Anonymous   
Printed
Page 41
line 6

resultss should be results

Anonymous   
Printed
Page 56
line 6

DISTINCT | | DISTINCTROWS should be: DISTINCT | DISTINCTROWS

Anonymous   
Printed
Page 56
line 6

DISTINCT | | DISTINCTROWS should be: DISTINCT | DISTINCTROWS

Anonymous   
Printed
Page 57
"Aliases" 5th line

are not be should be: have not been

Anonymous   
Printed
Page 57
"Aliases" 5th line

are not be should be: have not been

Anonymous   
Printed
Page 58
"Table1, Table2, Table3, ..." line 5;

) Only should be: ). Only

Anonymous   
Printed
Page 58
"Table1, Table2, Table3, ..." line 5;

) Only should be: ). Only

Anonymous   
Printed
Page 61
line -4;

Start with '#', not 'S'

Anonymous   
Printed
Page 61
line -4;

Start with '#', not 'S'

Anonymous   
Printed
Page 70
AVG

bad line break splitting "e.g."

Anonymous   
Printed
Page 70
AVG

bad line break splitting "e.g."

Anonymous   
Printed
Page 71
STD;

Use of '/' looks like division. Instead use ' | '

Anonymous   
Printed
Page 71
ADDDATE

Remove second and third commas.

Anonymous   
Printed
Page 71
STD;

Use of '/' looks like division. Instead use ' | '

Anonymous   
Printed
Page 71
ADDDATE

Remove second and third commas.

Anonymous   
Printed
Page 72
BIN

In the text, make "decimal" italic.

Anonymous   
Printed
Page 72
BIN

In the text, make "decimal" italic.

Anonymous   
Printed
Page 74
DATE_ADD

Remove second and third commas.

Anonymous   
Printed
Page 74
DATE_ADD

Remove second and third commas.

Anonymous   
Printed
Page 75
DATE_SUB

Add spaces between the words in the second parameter.

Anonymous   
Printed
Page 75
DATE_SUB

Add spaces between the words in the second parameter.

Anonymous   
Printed
Page 83
RIGHT,

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

Anonymous   
Printed
Page 83
RIGHT,

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

Anonymous   
Printed
Page 84
RTRIM

Correct the back tick to use typewriter font.

Anonymous   
Printed
Page 84
RTRIM

Correct the back tick to use typewriter font.

Anonymous   
Printed
Page 85
SUBSTRING,

The example for the fourth function should be with the second function.

Anonymous   
Printed
Page 85
SUBSTRING,

The example for the fourth function should be with the second function.

Anonymous