PrintNumber ErrorLocation Error Correction DateAdded
1 pii First Printing: October 2012 Second Printing: July 2013 6/10/2013
1 p22 The first number is where to start, and the second is the number of rows to retrieve. The first number is the number of rows to retrieve, and the second is where to start. 6/14/2013
1 p23 TIP: MySQL and MariaDB Shortcut
MySQL and MariaDB support a shorthand version of LIMIT 4
OFFSET 3, enabling you to combine them as LIMIT 3,4.
TIP: MySQL, MariaDB, and SQLite Shortcut
MySQL, MariaDB, and SQLite support a shorthand version of LIMIT 4 OFFSET 3, enabling you to combine them as LIMIT 3,4.
6/14/2013
1 p24 If you were working with a long SQL statement, and wanted to test just part of it, you could comment out some of the code so that MariaDB saw it as comments and ignored it. If you were working with a long SQL statement, and wanted to test just part of it, you could comment out some of the code so that DBMS saw it as comments and ignored it. 6/14/2013
1 p41 2nd Input:

FROM CUSTOMERS
FROM Customers 6/14/2013
1 p56 TIP: Searching for Partial Email Addresses
There is one situation in which wildcards may indeed be useful in the middle of a search pattern, and that is looking for e-mail addresses based on a partial address, such as WHERE email LIKE b%@forta.com.
TIP: Searching for Partial Email Addresses
There is one situation in which wildcards may indeed be useful in the middle of a search pattern, and that is looking for e-mail addresses based on a partial address, such as WHERE email ‘LIKE b%@forta.com’.
6/14/2013
1 p107 Input block:

FROM Order
FROM Orders 6/14/2013
1 p210 Middle of page:

@cust_country, @cust_contact, @cust_email
WHILE @@FETCH_STATUS = 0
@cust_country, @cust_contact, @cust_email
...
WHILE @@FETCH_STATUS = 0
6/14/2013
1 p215 Middle of page:

vend_zip CHAR(10) NULL
vend_zip CHAR(10) NULL, 6/14/2013
1 p221 Input:

ON PRODUCTS (prod_name);
ON Products (prod_name); 6/14/2013