MySQL in a Nutshell

Errata for MySQL in a Nutshell

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 94
in alphabetical order, there is supposed to be an UPDATE statement.

The missing content on the UPDATE statement is here - http://www.oreilly.com/catalog/9780596007898/ch04_update.html

Anonymous   
Printed
Page 100
DECODE() syntax

ENCODE -> DECODE ####################################

Anonymous    Apr 01, 2007
Printed
Page 140
2nd para - under UTC_DATE

Universal Time Clock -> Universal Time, Coordinated ####################################

Anonymous    Apr 01, 2007
Printed
Page 150
Section on MAX(), 1st sentence

This function returns the lowest number in the values for column. -> This function returns the highest number in the values for column. ####################################

Anonymous    Apr 01, 2007
Printed
Page 205
"Capturing Data" section, code snippet

{ print "$title ($author} "; } -> { print "$title ($author) "; } ####################################

Anonymous    Apr 01, 2007
Printed
Page 207
1st paragraph, sentences 4-5

Each record's array is parsed into separate variables. The the values of the variables are displayed. -> Each record's array is parsed into separate variables, then the values of the variables are displayed. ####################################

Anonymous    Apr 01, 2007
Printed
Page 255
first code snippet

exit() -> exit(EXIT_FAILURE) ####################################

Anonymous    Apr 01, 2007
Printed
Page 255
second code snippet

exit(EXIT FAILURE) -> exit(EXIT_FAILURE) ####################################

Anonymous    Apr 01, 2007
Printed
Page 255
Compile command

-L/usr/include/mysql -> -I/usr/include/mysql ####################################

Anonymous    Apr 01, 2007
Printed
Page 256
first code snippet

exit(EXIT SUCCESS); -> exit(EXIT_SUCCESS); ####################################

Anonymous    Apr 01, 2007