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 xxv
Missing word. The sentence that read "...where filename is the name of the

containing the CREATE TABLE statement"

NOW READS:
"...where filename is the name of the file containing the CREATE TABLE statement".

 Anonymous  Dec 2003
Printed Page 5
1st paragraph

1st sentence: "The table is named limbs and contains three columns to records (sic)
the number of legs..."

"records" should be "record"

 Anonymous 
Printed Page 40
Last paragraph, 2nd to last sentence

The sentence, "It contains only of (sic) the queries you issue, ..." should be: "It
contains only the queries you issue, ..."

 Anonymous 
Printed Page 44
2nd paragraph, 3rd sentence

The sentence, "Note that moving the script make (sic) cause...", should be: "Note
that moving the script may cause...".

 Anonymous 
Printed Page 61
In the first example under "Additional connection parameters", the unix_sock

parameter NOW READS unix_socket.

 Anonymous  Dec 2003
Printed Page 69
Typo. "if you omit" NOW READS "If you omit".

Anonymous  Dec 2003
Printed Page 115
The reference to Recipe 2.8 in the first sentence was incorrect. It NOW READS to Recipe 2.7.

Anonymous  Dec 2003
Printed Page 174
The query at the bottom of the page

mysql> SELECT name,
DATE_FORMAT(birth,'%m-%e') AS birthday
-> FROM profile ORDER BY
birthday LIMIT 1;

NOW READS:
mysql> SELECT name,
DATE_FORMAT(birth,'%m-%d') AS birthday
-> FROM profile ORDER BY
birthday LIMIT 1;

 Anonymous  Dec 2003
Printed Page 257
Extraneous word. The second paragraph that began "For values that occur

prior outside the range..." NOW READS "For values that occur outside
the range..."

 Anonymous  Dec 2003
Printed Page 353
This clause: ...the only values you can select are the grouped columns

or the summary values calculated from them. NOW READS: ...the only values
you can select are the grouped columns or summary values calculated from
the groups.

 Anonymous  Dec 2003
Printed Page 365
Typo in query column header. The first query on the p. 365 was printed

as:

mysql> SELECT name, COUNT(*) AS days, SUM(miles) AS mileage
-> FROM driver_log GROUP BY name;
+-------+------+-------------+
| name | days | total miles |
+-------+------+-------------+
| Ben | 3 | 362 |
| Henry | 5 | 911 |
| Suzi | 2 | 893 |
+-------+------+-------------+

NOW READS:

mysql> SELECT name, COUNT(*) AS days, SUM(miles) AS mileage
-> FROM driver_log GROUP BY name;
+-------+------+---------+
| name | days | mileage |
+-------+------+---------+
| Ben | 3 | 362 |
| Henry | 5 | 911 |
| Suzi | 2 | 893 |
+-------+------+---------+

 Anonymous  Dec 2003
Printed Page 367
Typo in query. The second query on p. 367

mysql> SELECT name, SUM(miles)
-> FROM driver_log
-> GROUP BY name
-> HAVING SUM(miles) = MAX(SUM(name));
ERROR 1111 at line 1: Invalid use of group function

NOW READS:
mysql> SELECT name, SUM(miles)
-> FROM driver_log
-> GROUP BY name
-> HAVING SUM(miles) = MAX(SUM(miles));
ERROR 1111 at line 1: Invalid use of group function

 Anonymous  Dec 2003
Printed Page 402
Typos. Near the bottom of the page, these two lines

$name = $sth->{NAMES}->[$i];

@names = @{$sth->{NAMES}};

NOW READ:
$name = $sth->{NAME}->[$i];

@names = @{$sth->{NAME}};

 Anonymous  Dec 2003
Printed Page 444
Typo. A comma should have been a period. "representative techniques and

utilities, You" NOW READS "representive techniques and utilities. You".

 Anonymous  Dec 2003
Printed Page 445
First bullet, 3rd sentence

"This many (sic) involve issues such as..." should be: "This may involve issues such
as..."

 Anonymous 
Printed Page 446
Typo. A comma should have been a period. "column delimiters, On" NOW READS "column

delimiters. On".

 Anonymous  Dec 2003
Printed Page 501
The last paragraph stated that the range for hour values is 0 to 24. It

NOW READS 0 to 23.

 Anonymous  Dec 2003
Printed Page 502
The line

$hour += 12 if defined ($4) && uc ($4) eq "PM";

NOW READS:

$hour += 12 if defined ($4) && uc ($4) eq "PM" && $hour != 12;

 Anonymous  Dec 2003
Printed Page 517
The syntax for the fifth option for guess_table.pl was described as

--tbl_name=tbl_name. NOW READS --table=tbl_name.

 Anonymous  Dec 2003
Printed Page 530
Typo. "The script rewrites dates the contents" NOW READS "The script

rewrites the contents".

 Anonymous  Dec 2003
Printed Page 548
The first bullet stated

"With ISAM and BDB tables, the next sequence number always is the smallest
positive integer not currently present in the column."

NOW READS:
"With ISAM and BDB tables, the next sequence number always is the maximum
integer currently present in the column plus one."

 Anonymous  Dec 2003
Printed Page 794
Typos. The code display near the bottom of the page was missing some

closing double quotes. The code read:

<a href="#1>Chapter 1</a>
<a href="#2>Chapter 2</a>
<a href="#3>Chapter 3</a>

NOW READS:

<a href="#1">Chapter 1</a>
<a href="#2">Chapter 2</a>
<a href="#3">Chapter 3</a>

 Anonymous  Dec 2003
Printed Page 801
Typo. "fix-length types" NOW READS "fixed-length types".

Anonymous  Dec 2003
Printed Page 802
Typo. In the introductory comment "store in that image table", NOW READS

"store in the image table".

 Anonymous  Dec 2003
Printed Page 809
Typo. The banner.py descriptive comment "server randomly chosen banner ad"

NOW READS "serve randomly chosen banner ad".

 Anonymous  Dec 2003
Printed Page 873
Typo. In the second sentence, "how many row" NOW READS "how many rows".

Anonymous  Dec 2003