Errata
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 V4 - Preface XVI "How to Contact Us" area just below the address for O'Reilly |
Ms Zhao, first let me say that I am enjoying your 4th edition of SQL Pocket Guide. |
Stanley Moore | Oct 20, 2021 | Dec 06, 2021 |
Printed | Page Cover Top right corner |
From a marketing perspective, one of the things that people like about the book and prompt them to buy the book is that it covers multiple flavors of SQL. This isn't prominently displayed on the cover, however. |
Alice Zhao |
Oct 26, 2021 | Dec 17, 2021 |
Printed | Page 1 Under the SQL section, under the first paragraph |
Currently the text is: |
Alice Zhao |
Sep 09, 2021 | Dec 17, 2021 |
Printed | Page 40 Top |
The notes at the top of pages 40 and 41 have different capitalization. They should match. |
Alice Zhao |
Sep 09, 2021 | Dec 17, 2021 |
Printed | Page 74 Last paragraph of the tip |
The formatting of the Show... section should match the formatting of the Filter... section. Specifically, the (or... Server) section should be moved down a line and indented like the Better yet... section above. |
Alice Zhao |
Sep 09, 2021 | Dec 17, 2021 |
Printed | Page 109, 237, 269, 272, 311 Headers in the tables |
During production, I requested that the indentation be removed from any column with bolded code. I see that this was applied in some of the tables in the book, but there are a few that were missed: |
Alice Zhao |
Sep 09, 2021 | Dec 17, 2021 |
Page 180 Table 7-1 |
The last line in column 2 currently shows: Note from the Author or Editor: |
Alice Zhao | Feb 07, 2022 | ||
Printed | Page 273 Entire table |
The third column of the table is squished and the code inside wraps around. This is likely due to me requesting that NATURAL stay one word within the first column. It is more important for the code in the third column not to wrap around, so please remove the NATURAL constraint and widen the third column. |
Alice Zhao |
Sep 09, 2021 | Dec 17, 2021 |
Printed | Page 274 Top right cell |
The > before the SELECT statement should be removed. It should look like: |
Alice Zhao |
Sep 09, 2021 | Dec 17, 2021 |