Errata
The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
Version | Location | Description | Submitted by | Date submitted |
---|---|---|---|---|
Printed | Page 24 dealing with WHERE clause |
Not really an error, but a strong suggestion: |
Anonymous | |
Printed | Page 24 dealing with WHERE clause |
sorry, not really an error, but a strong suggestion: |
Anonymous | Jul 01, 2008 |
Printed | Page 32 Last paragraph of page |
The paragraph refers to a TEXT_FIELDS clause on the LOAD DATA INFILE statement. I am unable to find any confirmation that that clause is recognized or supported by MySQL 5.1. I referred to the online MySQL manual at http://dev.mysql.com/doc/refman/5.1/en/load-data.html, as well as the PDF manual for 5.0. |
Anonymous | Jan 12, 2010 |
Printed | Page 34 Top SELECT statement |
The SELECT statement is missing a 'FROM authors' line. |
Stuart Ashton | Jul 27, 2012 |
Printed | Page 54 2/3 down the page |
Under the heading for SHA1(), the subheading says SHA(string). It should say SHA1(string). |
Anonymous | |
Printed | Page 54 2/3 down the page |
Under the heading for SHA1(), the subheading says SHA(string). It should say SHA1(string). |
Anonymous | Jun 19, 2008 |
Printed | Page 66 4th paragraph |
the CHANGE clause is used to change the name of the city column,but not its column type and size. (CHANGE is both the name and data type of an existing column) and the example above 4th paragraph changes data type size. Shouldn't the paragraph above read: the CHANGE clause is used to change the name of the city column and column size,but not its position. |
laserled | Jul 11, 2010 |
Printed | Page 83 CREATE TABLE statement syntax specification |
Replace |
Anonymous | Sep 09, 2008 |
Printed | Page 94 Next to last statement heading |
I own the first edition of this book (ISBN 0-596-00789-2), but I have also noticed the problem in the second edition by examining what I could of it online. I also am not sure of the page numbers in the second edition. |
Don Gillespie | Apr 26, 2010 |
Page 131 Line 11 |
It says lines in Windows are terminated by /n/r. Shouldn't it be /r/n |
Robert Davies | Jul 28, 2010 | |
Printed | Page 150 Under the definition for MAX |
The definition for MAX should read "This function returns the highest number..." instead of "lowest number" |
Anonymous | Feb 19, 2009 |
Printed | Page 240 & 249 . |
I found an error on pg 240 that is also repeated on page 249 of the second |
Anonymous | May 31, 2013 |