The first two lines on the page look like this:

# cp mysql.server /etc/rc.d/init.d
# cd
/etc/init.d

The second line is incorrect; the lines should look like this:

# cp mysql.server /etc/rc.d/init.d
# cd
/etc/rc.d/init.d

The return values for STRCMP() are incorrect. This function returns 1, 0, or -1 if the first argument is lexicographically greater than, equal to, or less than the second argument. If either argument is NULL, the function returns NULL.

A better set of examples would be:

STRCMP("a","a") -> 0
STRCMP("a","A") ->
1
STRCMP("A","a") ->
-1

The description says "Returns the largest integer not greater than x (that is, x with the fractional part chopped off)." Unfortunately, the part in parentheses is true only for positive integers. For negative numbers, the result is not simply a fractional chop. Delete the phrase in parentheses.

The superscript for the upper range of the length of TINYTEXT values is incorrect. The range is 0 to 2^8 - 1 bytes, not 0 to 2^87 - 1 bytes.

The syntax line for the selectcol_arrayref() method is incorrect. The method returns a reference to an array ($ary_ref), not an array (@ary_ref).

There is a print() statement that should be a printf() statement.

Change this line:

print ("number of
rows returned: %d\n", mysql_num_rows ($result));

To this:

printf ("number of rows returned: %d\n",
mysql_num_rows
($result));

The paragraph begins by referencing the mysql_rows_affected() function. The function name should be mysql_affected_rows().

The third row from the bottom of the lowest box has an ad_num value of 48. As such, it should have an arrow leading to it from the 48 in the middle box. But let's just pretend it has a value of 49 instead.

If the series begins at 1,000,000, you'll be able to add nine million customers before the digit count changes, not one million as the text says.

Change:

You'll be able to add a million ...

To:

You'll be able to add well over a million ...

Change:

... you need not supply leading two digits for month and day values that are less than 10.

To:

... you need not supply a leading zero digit for month or day values that are less than 10.

Change:

... exits when an error occurs, and is an error ...

To:

... exits when an error occurs, and it is an error ...

Change:

SELECT ... FROM
t1

To:

SELECT * FROM
t1

The workaround for versions of MySQL older than 3.23 should not use TYPE=HEAP, because HEAP tables were introduced in MySQL 3.23.

Change the second line of the example:

TYPE=HEAP SELECT ... FROM table1 WHERE
...

To:

SELECT ... FROM table1 WHERE
...

The text of the paragraph does not match the preceding syntax description.

Change:

Everything in this syntax is optional except the word SELECT and the column_list part ...

To:

Everything in this syntax is optional except the word SELECT and the selection_list part ...

Extraneous space.

Change:

... can use arithmetic operators , as in Table 1.1 ...

To:

... can use arithmetic operators, as in Table 1.1 ...

Change:

Use the module version by default and the standalone version for situations in which scripts with the privileges of a particular user.

To:

Use the module version by default and the standalone version for situations in which scripts need to run with the privileges of a particular user.

Change:

while (@ary =
$sth->fetchrow_array ())
{77
    $delim =
"";

To:

while (@ary =
$sth->fetchrow_array ())
{
    $delim =
"";

Change:

The DBI_DSN environment variable is used if the data source is undefined or the empty string is undefined.

To:

The DBI_DSN environment variable is used if the data source is undefined or is the empty string.

Change:

</HEAD>            <-
beginning of document
head

To:

</HEAD>
<- end of document
head

The output from the Perl script is missing a character.

Change:

x<=y,
right

To:

x<=y,
right?

The phrase "GNU's Not UNIX" is missing the trailing double quote.

The row-fetching code in the last example on the page uses mysql_fetch_array(), but the following paragraph refers to mysql_fetch_row(). The paragraph should say mysql_fetch_array():

To get this value, we pass the result set identifier to mysql_fetch_array() to fetch the row, assign the row to the variable $row, and access the first element as $row[0].

Change:

For versions of MySQL prior to 3.23, it's essential that joined columns be of the same time ...

To:

For versions of MySQL prior to 3.23, it's essential that joined columns be of the same type ...

Change:

The DECIMAL type differs from FLOAT and DECIMAL in that DECIMAL ...

To:

The DECIMAL type differs from FLOAT and DOUBLE in that DECIMAL ...

Change:

Our member table will use separate ...

To:

Our president table will use separate ...

There are three instances of "Maryland" on these pages. They all should be "Massachusetts" (the example queries look for state="MA").

The state abbreviation for Arkansas is AR, not AK. Change the AK in the listing to AR.

The state abbreviation for Arkansas is AR, not AK. Change the AK in the listing to AR.

The state abbreviation for Arkansas is AR, not AK. Change the AK in the listing to AR.

Change:

For example, (4*3)/(4-2) evaluates to the value 2.

To:

For example, (4*3)/(4-2) evaluates to the value 6.

There should not be two bullets for the SIN() function. The text of the second SIN() bullet is part of the preceding description.

There is an instance of addslashes() written incorrectly as $addslashes().

Change:

addslashes
($date), $addslashes
($type));

To:

addslashes
($date), addslashes
($type));

Change:

The tables in the samp_db table are relatively ...

To:

The tables in the samp_db database are relatively ...

And change:

If you edit samp_db to display tables from ...

To:

If you edit samp_browse to display tables from ...

Change the query that says:

SELECT birth_date FROM
...

To:

SELECT birth FROM
...

The output should look like this:

+-----------+-----+------------+
| name      | sex | student_id |
+-----------+-----+------------+
| Megan     | F   |          1 |
| Joseph    | M   |          2 |
| Kyle      | M   |          3 |
| Katie     | F   |          4 |
...

The output should look like this:

+-----------+
| name      |
+-----------+
| Megan     |
| Joseph    |
| Kyle      |
| Katie     |
...

The output should look like this:

+-----------+-----+------------+
| name      | sex | student_id |
+-----------+-----+------------+
| Megan     | F   |          1 |
| Joseph    | M   |          2 |
| Kyle      | M   |          3 |
| Katie     | F   |          4 |
...

The output should look like this:

+------------+----------+-------+
| student_id | event_id | score |
+------------+----------+-------+
|          5 |        3 |    97 |
|         18 |        3 |    96 |
|          1 |        6 |   100 |
|          5 |        6 |    97 |
|         11 |        6 |    98 |
|         16 |        6 |    98 |
+------------+----------+-------+

The output is missing from the book. It should look like this:

+-----------+------------+
| last_name | first_name |
+-----------+------------+
| Polk      | James K.   |
| Taft      | William H. |
| Ford      | Gerald R   |
| Bush      | George W.  |
+-----------+------------+

The rows of the output are reversed. They should look like this:

+-----+----------+
| sex | COUNT(*)
|
+-----+----------+
| F   |       15 |
| M   |       16
|
+-----+----------+

The query produces no more lines of output than are shown. The "..." is incorrect.