Errata for Sams Teach Yourself SQL in 10 Minutes (Fourth 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 (Fourth 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 (276 pages, published November 4, 2012)

19Paragraph following the OUTPUT block: 14 rowsShould be: 9 rows
19Paragraph following the OUTPUT block: 14 productsShould be: 9 products
20First paragraph, “only four rows”Should be: only three rows
20Caution block, words: “unless both”Should be: “because both”
22Second ANALYSIS block, second sentanceShould be: The first number is the number of rows to retrieve, and the second number is where to start.
23TIPThis TIP applies to SQLite as well
23Tip, second sentenceShould be: “Using this syntax, the value before the , is the OFFSET and the value after the , is the LIMIT.”
23Bullet at bottom of page, “SQL statement grow”Should be: SQL statements grow
24First bullet, “at the top of SQL file”Should be “at the top of the SQL file”
24First paragraph after bullets, “We’ll Start”Should be: We’ll start
24Second bullet, words “so that MariaDB”Should be: “so that the DBMS”
41Second INPUT block, “FROM CUSTOMERS”Should be: FROM Customers
56TIP, closing WHERE clauseShould be: WHERE email LIKE ‘’
58Note, first line: describesShould be: described
62Final paragraph, “The reports wants”Should be: The report wants
63First paragraph, “the three columns”Should be: the two columns
64Third bullet, “state stored”Should be: country stored
79Input block at top of page, 2012 in WHERE clause.Should be: ‘2012’
83Caution block.Add the following to the caution. “The exception to this is when returning a single value that is calculated from multiple columns, as will be explained later in this lesson.”
107INPUT block, middle SELECT statement: FROM OrderShould be: FROM Orders
109Paragraph beginning, “The WHERE clause”, words “column names, instead of”Should be: column names; instead of
111CAUTION block, 5th line, text “if you”Should be: if your
120First paragraph, “as the preceding example”Should be: as an earlier example
126Paragraph beginning “So far”, “You’ll Now take a look at”Should be: You’ll now look at
127Analysis section, last line: “Subqeries”Should be: Subqueries
131CAUTION block, first line, words LEFT OUT JOINShould be: LEFT OUTER JOIN
143NOTE block, first lineMissing a . after word UNION
164First paragraph, third line. “that You”Should be: that you
183Note, “was a rather”Should be: is rather
199Last paragraph, “what transactions processing is”Should be: what transaction processing is
201First paragraph, last line, “undo then”Should be: undo them
205NOTE block, first line, words “does support”Should be: does not support
210INPUT blockANALYSIS refers to a … placeholder, but it is missing from the code snippet.
215First INPUT block, line beginning vend_zipThis line is missing its trailing , character
221INPUT block: ON PRODUCTSShould be: ON Products
230Paragraph beginning “The SQL statements”, words “these file”Should be: these files
235Step 2, “available database”Should be: available databases
241“Using Oracle” step 1, “using provided”Should be: using the provided
241Using Oracle section, item 2, words “Before you can any”Should be: Before you can use any
242Using Oracle Express Step 4, “enter and text SQL”Should be: enter any SQL text
254Paragraph beginning “Fixed length”, words “padded with spaces or nulls”Should be: padded with spaces
263TAPEShould be: TYPE