Errata for Sams Teach Yourself SQL in 10 Minutes (Fifth Edition)

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 errata 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)

20First ANALYSIS block.Text states that the output "is shown in the following code", bit it isn't.
21Using 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.
22Second ANALYSIS block.File name create.sql should be create.txt, and file name populate.sql should be populate.txt.
311st challenge: (cust_names)Should be: (cust_name)
43Output blockShould include column prod_id
53Tip, 'LIKE'Should be: LIKE ''
62ANALYSIS block, 2nd bullet.Should read: A string containing an open parenthesis, preceded by a space in the MySQL / MariaDB example.
72Table 8.2, Function column, first entryMissing closing )
78Challenge 1, text “customer name (customer_name)”Should be: customer name (cust_name)
88Challenge 2, text "of product item(prod_item)"Should be: of products with an id (prod_id)
100Text after 2nd OUTPUT block, words "order number, 20007 and 20008".Should be: order numbers 20007 and 20008
101ANALYSIS block, both SELECT statements.orders should be Orders, orderitems should be OrderItems
106Challenge 3, final words "from Customers"Should be: from Orders
129Second INPUT blockShould be:
SELECT cust_name, cust_contact, cust_email
FROM Customers
WHERE cust_state IN ('IL','IN','MI') OR cust_name='Fun4All';
152INPUT block, text: CHAR(254)Should be: CHAR(255)
1691st INPUT blockSQL statement should ideally be terminated with a semicolon (the ; character)
189Using Cursors section, text "using the OPEN CURSOR statement"Should be: using the OPEN statement followed by the cursor name
1892nd INPUT, text "OPEN CURSOR CustCursor"Should be: OPEN CustCursor
1892nd ANALYSIS block, text "When the OPEN CURSOR statement"Should be: When the OPEN CustCursor Statement
191INPUT block, text "DEALLOCATE CURSOR CustCursor"Should be: DEALLOCATE CustCursor
1961st INPUT block, text "ADD CONSTRAINT"Should be: ADD CONSTRAINT FK_CustomerOrder
1982nd INPUT block, text "ADD CONSTRAINT CHECK"Should be: ADD CONSTRAINT CHK_gender