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)
|7||First line of summary||Should read “you learned what SQL is and why it is useful.”|
|12||Paragraph beginning “When a wildcard”.||Last sentence should read “This should therefore not present a problem”.|
|55||Summary text.||Word “implementation” spelled incorrectly.|
|60||First line of the description of the MIN() function.||Extraneous character after the word MAX().|
|79||Summary text.||Word “saw” spelled incorrectly in third line.|
|79||Final sentence of last paragraph.||Word “these” is misspelled.|
|97||Code 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(+);”.|
|150||Second code input block, second line.||Should read: ADD CONSTRAINT name PRIMARY KEY (vend_id)|
|151||Last line of code on page.||Missing word ADD before the word CONSTRAINT.|
|154||INPUT block at top of page.||Missing word ADD before the word CONSTRAINT.|
|161||Note at top of page, second to last line.||Should read “most real installations. You can apply these techniques”.|
|167||Third 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”.|