Errata

Print Print Icon

Submit your own errata for this product.


The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question



Version Location Description Submitted By Corrected
Printed Page 5
Figure 1, three table names (top compartment of each box)

"county_id", "city_id", and "attraction_id"

NOW READ:
"county", "city", and "attraction"

AND

Figure 2, the primary key column of the cd table:
"city_id"

NOW READS
"cd_id"

AND

Figure 2, a third field "name" HAS BEEN ADDED to the song
table, prior to the ellipses.

Anonymous  Mar 2005
Printed Page 7
final code example

...
END
FROM attraction;

NOW READS:
...
END casegove
FROM attraction;

(32/33) Table 6;
The following two entries HAVE BEEN ADDED to Table 6 on page 33:

%I Hour, two digits, 12-hour clock: 01...12

%i Minutes: 00, 01, ... 59

 Anonymous  Mar 2005
Printed Page 25
Table 3 continued, line 3 on this page

Style 111 assigned to Japanese date format, given as yyyy/mm/yy NOW READS yyyy/mm/dd.

 Anonymous  May 2004
Printed Page 52
Extracting a substring subsection, 1st sentence

NOW READS:
"In Oracle and DB2, use the SUBSTR function to extract length characters from a string...."

 Anonymous  Jun 2005
Printed Page 52
Extracting a substring subsection, final sentence before "Tip" box

The final sentence has been DELETED. The last sentence before the "Tip" box NOW READS:

"DB2 pads any result with spaces, if necessary, to ensure the result is always length characters long.

 Anonymous  Jun 2005
Printed Page 53
2nd paragraph and first code explanation of required arguments

NOW READ:

"In SQL Server use SUBSTRING, and all three arguments are required:
SUBSTRING(string, start, length)

 Anonymous  Jun 2005
Printed Page 100
Last paragraph, 2nd sentence

"You can use the percent (%) and period (.) characters to match any number of characters or any one character, respectively."

NOW READS:
"You can use the percent (%) and underscore (_) characters to match any number of characters or any one character, respectively."

 Anonymous  Mar 2005
Printed Page 111
final paragraph, parenthetical phrase

(Note that MySQL is an exception...)

NOW READS:
(In MySQL, whether table names are case-sensitive
depends on whether the underlying operating system is
case-sensitive with respect to filenames.)

 Anonymous  Mar 2005