Errata

MySQL Cookbook

Errata for MySQL Cookbook

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 "Date 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 Note Update

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 501
The last paragraph stated that the range for hour values is 0 to 24. It

NOW READS 0 to 23.

 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

rewrites the contents".

 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