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 "Date Corrected".
The following errata were submitted by our customers and approved as valid errors by the author or editor.
| Version |
Location |
Description |
Submitted By |
Date Submitted |
Date 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 01, 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 01, 2003 |
| Printed |
Page 69
Typo. "if you omit" NOW READS "If you omit". |
|
Anonymous |
|
Dec 01, 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 01, 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 01, 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 01, 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 01, 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 01, 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 01, 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 01, 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 01, 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 |
|
Anonymous |
|
Dec 01, 2003 |
| Printed |
Page 501
The last paragraph stated that the range for hour values is 0 to 24. It |
|
Anonymous |
|
Dec 01, 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 01, 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 01, 2003 |
| Printed |
Page 530
Typo. "The script rewrites dates the contents" NOW READS "The script |
|
Anonymous |
|
Dec 01, 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 01, 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 01, 2003 |
| Printed |
Page 801
Typo. "fix-length types" NOW READS "fixed-length types". |
|
Anonymous |
|
Dec 01, 2003 |
| Printed |
Page 802
Typo. In the introductory comment "store in that image table", NOW READS |
"store in the image table".
|
Anonymous |
|
Dec 01, 2003 |
| Printed |
Page 809
Typo. The banner.py descriptive comment "server randomly chosen banner ad" |
NOW READS "serve randomly chosen banner ad".
|
Anonymous |
|
Dec 01, 2003 |
| Printed |
Page 873
Typo. In the second sentence, "how many row" NOW READS "how many rows". |
|
Anonymous |
|
Dec 01, 2003 |
