library_image

Errata: Sams Teach Yourself SQL in 10 Minutes (Fourth Edition)

Errata: Sams Teach Yourself SQL in 10 Minutes (Fourth Edition)


Original printing (276 pages, published November 4, 2012)

PageLocationCorrection
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 ‘b%@forta.com’
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