library_image

Errata: Sams Teach Yourself SQL in 10 Minutes

Home » Errata: Sams Teach Yourself SQL in 10 Minutes

Errata: Sams Teach Yourself SQL in 10 Minutes


Original printing (212 pages, published September 1, 1999)

PageLocationCorrection
7First line of summaryShould read “you learned what SQL is and why it is useful.”
12Paragraph beginning “When a wildcard”.Last sentence should read “This should therefore not present a problem”.
55Summary text.Word “implementation” spelled incorrectly.
60First line of the description of the MIN() function.Extraneous character after the word MAX().
79Summary text.Word “saw” spelled incorrectly in third line.
79Final sentence of last paragraph.Word “these” is misspelled.
97Code listing in third Input block (Oracle example).Final line of code is missing a plus sign and a trailing semi-colon, it should read “WHERE Customers.cust_id = Orders.cust_id(+);”.
150Second code input block, second line.Should read: ADD CONSTRAINT name PRIMARY KEY (vend_id)
151Last line of code on page.Missing word ADD before the word CONSTRAINT.
154INPUT block at top of page.Missing word ADD before the word CONSTRAINT.
161Note at top of page, second to last line.Should read “most real installations. You can apply these techniques”.
167Third to last bullet on the page.Should read “To enforce referential integrity, foreign keys should be defined on order_num relating it to order_num in ORDERS, and prod_id relating it to prod_id in PRODUCTS”.