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 |