Errata
Sams Teach Yourself SQL in 10 Minutes · ISBN 0135182794 · 22 corrections
Initial printing
| 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_emailFROM CustomersWHERE 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 | 2nd ANALYSIS block, text “When the OPEN CURSOR statement” | Should be: When the OPEN CustCursor Statement |
| 189 | 2nd INPUT, text “OPEN CURSOR CustCursor” | Should be: OPEN CustCursor |
| 189 | Using Cursors section, text “using the OPEN CURSOR statement” | Should be: using the OPEN statement followed by the cursor name |
| 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 |