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 4 (Example file) mysql_sample_data.sql |
The following command is rejected by MySQL 5.0.41 using phpMyAdmin 2.10.2. I'm running everything under MAMP on Mac. |
Anonymous | |
Printed | Page 4 (Example file) mysql_sample_data.sql |
The following command is rejected by MySQL 5.0.41 using phpMyAdmin 2.10.2. I'm running everything under MAMP on Mac. |
Anonymous | |
Printed | Page 4 Second Paragraph |
The sample data for MYSQL does not work. The table name 'dual' (line 146) cannot be created because 'dual' is a reserved word. Performing a find/replace on 'dual', changing it to 'duel' for example, fixes the problem. |
Anonymous | |
Printed | Page 8 Max precision/scale section |
For Oracle the book gives a maximum precision of 38 and a maximum scale of 127. I believe the precision must always be greater than or equal to the scale. |
Anonymous | |
Printed | Page 8 Max precision/scale section |
For Oracle the book gives a maximum precision of 38 and a maximum scale of 127. I believe the precision must always be greater than or equal to the scale. |
Anonymous | |
Printed | Page 24 End of table 3 |
Format should be yyyy-mm-ddThh:mm:ss.mmm |
Anonymous | Jun 04, 2012 |
Printed | Page 52 3rd paragraph beginning with "In DB2, use either LOCATE or POSSTR |
It says: |
Anonymous | |
Printed | Page 52 3rd paragraph beginning with "In DB2, use either LOCATE or POSSTR |
It says: |
Anonymous | |
Printed | Page 85 3rd para |
You wrote "... then it joins the table of months to upfall..." |
Anonymous | |
Printed | Page 85 3rd para |
You wrote "... then it joins the table of months to upfall..." |
Anonymous | |
Printed | Page 102 Between Predicates |
The example for BETWEEN is misleading. it is not <= to the higher value. |
Anonymous | |
Printed | Page 102 Between Predicates |
The example for BETWEEN is misleading. it is not <= to the higher value. |
Anonymous |