Errata for Sams Teach Yourself SQL in 10 Minutes

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. 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 (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”.