Sams Teach Yourself SQL in 10 Minutes - Fourth Edition
- ISBN: 0672336073
- Pages: 276
- Publisher: Sams - November 4, 2012
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.
Location: Paragraph following the OUTPUT block: 14 rows
Error: Should be: 9 rows
Location: Paragraph following the OUTPUT block: 14 products
Error: Should be: 9 products
Location: First paragraph, "only four rows"
Error: Should be: only three rows
Location: Caution block, words: "unless both"
Error: Should be: "because both"
Location: Second ANALYSIS block, second sentance
Error: Should be: The first number is the number of rows to retrieve, and the second number is where to start.
Error: This TIP applies to SQLite as well
Location: Tip, second sentence
Error: Should be: "Using this syntax, the value before the , is the OFFSET and the value after the , is the LIMIT."
Location: Bullet at bottom of page, "SQL statement grow"
Error: Should be: SQL statements grow
Location: First bullet, "at the top of SQL file"
Error: Should be "at the top of the SQL file"
Location: Second bullet, words "so that MariaDB"
Error: Should be: "so that the DBMS"
Location: Second INPUT block, "FROM CUSTOMERS"
Error: Should be: FROM Customers
Location: TIP, closing WHERE clause
Error: Should be: WHERE email LIKE 'email@example.com'
Location: Note, first line: describes
Error: Should be: described
Location: Final paragraph, "The reports wants"
Error: Should be: The report wants
Location: First paragraph, "the three columns"
Error: Should be: the two columns
Location: Third bullet, "state stored"
Error: Should be: country stored
Location: Input block at top of page, 2012 in WHERE clause.
Error: Should be: '2012'
Location: Caution block.
Error: 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."
Location: INPUT block, middle SELECT statement: FROM Order
Error: Should be: FROM Orders
Location: Paragraph beginning, "The WHERE clause", words "column names, instead of"
Error: Should be: column names; instead of
Location: CAUTION block, 5th line, text "if you"
Error: Should be: if your
Location: First paragraph, "as the preceding example"
Error: Should be: as an earlier example
Location: Paragraph beginning "So far", "You'll Now take a look at"
Error: Should be: You'll now look at
Location: CAUTION block, first line, words LEFT OUT JOIN
Error: Should be: LEFT OUTER JOIN
Location: NOTE block, first line
Error: Missing a . after word UNION
Location: NOTE block, first line, words "does support"
Error: Should be: does not support
Location: INPUT block
Error: ANALYSIS refers to a ... placeholder, but it is missing from the code snippet.
Location: First INPUT block, line beginning vend_zip
Error: This line is missing its trailing , character
Location: INPUT block: ON PRODUCTS
Error: Should be: ON Products
Location: Using Oracle section, item 2, words "Before you can any"
Error: Should be: Before you can use any