As much as I’d like to be able to produce completely error free books, the reality of the computer publishing industry is that the pace at which books must be written and released makes this very difficult. And regretfully, my own books do have sporadic mistakes and typos scattered throughout them.
For the benefit of my readers, here is a current erratum for Sams Teach Yourself SQL in 10 Minutes (Fifth Edition). Feel free to print this page for future reference.
And as always, if you come across errors that I do not know about, please let me know. I’ll make sure they are added to this list, and will try to have them corrected in future reprints.
Original printing (306 pages, published December 20, 2019)
| Page | Location | Correction |
|---|---|---|
| Page | Location | Correction |
| 20 | First ANALYSIS block. | Text states that the output “is shown in the following code”, bit it isn’t. |
| 21 | Using Comments, first and second bullets. | File name create.sql should be create.txt, and file name populate.sql should be populate.txt. In addition, the references to Appendix B should be Appendix A. |
| 22 | Second ANALYSIS block. | File name create.sql should be create.txt, and file name populate.sql should be populate.txt. |
| 31 | 1st challenge: (cust_names) | Should be: (cust_name) |
| 43 | Output block | Should include column prod_id |
| 53 | Tip, ‘LIKE b%@forta.com’ | Should be: LIKE ‘b%@forta.com’ |
| 62 | ANALYSIS block, 2nd bullet. | Should read: A string containing an open parenthesis, preceded by a space in the MySQL / MariaDB example. |
| 72 | Table 8.2, Function column, first entry | Missing closing ) |
| 78 | Challenge 1, text “customer name (customer_name)” | Should be: customer name (cust_name) |
| 88 | Challenge 2, text “of product item(prod_item)” | Should be: of products with an id (prod_id) |
| 100 | Text after 2nd OUTPUT block, words “order number, 20007 and 20008”. | Should be: order numbers 20007 and 20008 |
| 101 | ANALYSIS block, both SELECT statements. | orders should be Orders, orderitems should be OrderItems |
| 129 | Second INPUT block | Should be: SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state IN (‘IL’,’IN’,’MI’) OR cust_name=’Fun4All’; |
| 152 | INPUT block, text: CHAR(254) | Should be: CHAR(255) |
| 169 | 1st INPUT block | SQL statement should ideally be terminated with a semicolon (the ; character) |
| 189 | Using Cursors section, text “using the OPEN CURSOR statement” | Should be: using the OPEN statement followed by the cursor name |
| 189 | 2nd INPUT, text “OPEN CURSOR CustCursor” | Should be: OPEN CustCursor |
| 189 | 2nd ANALYSIS block, text “When the OPEN CURSOR statement” | Should be: When the OPEN CustCursor Statement |
| 191 | INPUT block, text “DEALLOCATE CURSOR CustCursor” | Should be: DEALLOCATE CustCursor |
| 195 | INPUT block, text “ADD CONSTRAINT PRIMARY KEY” | Should be: ADD CONSTRAINT PK_vendors PRIMARY KEY |
| 196 | 1st INPUT block, text “ADD CONSTRAINT” | Should be: ADD CONSTRAINT FK_CustomerOrder |
| 198 | 2nd INPUT block, text “ADD CONSTRAINT CHECK” | Should be: ADD CONSTRAINT CHK_gender |