Version is now 5.0.26

mysql> SELECT * FROM album WHERE album_id > 2
-> AND (NOT album_id) = 4 OR album_id = 6;
...
mysql> SELECT * FROM album WHERE (NOT album_id) = 4;
...
mysql> SELECT * FROM album WHERE (NOT album_id) != 4;

It should be clarified that the table that is created at the top of page 206 does not have any values stored in it, so the forthcoming queries of pages 206-207 will not work. This may puzzle beginners.

This error includes book's accompanying code. The book code excerpt has "time TIME" and says that this is preferred to the alternate DECIMAL type. However, the code has "time DECIMAL(5,2)" in file "data/music.sql". Elsewhere in the book it's clear from table outputs that the decimal type was used; errata on book website has changes this to DECIMAL(3,2). However, page 214 describes TIME as the preferred type. There should be consistency between the type used in the code, the table outputs, and the discussion on this page.

Note from the Author or Editor:
DECIMAL(5,2) is the choice used for the book; the errata actually correct to use this, not DECIMAL(3,2).

The SQL query example at top of page should be better chosen. While technically correct the chosen example is redundant and should be replaced with something more meaningful. In this case it makes no sense to use the FROM clause, since the parenthetical statement gives the same result. In other words, running:

mysql> SELECT producer_name, months FROM
-> (SELECT producer_name, years*12 AS months FROM producer) AS prod;

is equivalent to running:

SELECT producer_name, years*12 AS months FROM producer

...of access the user partmusic has for the database ResearchPeople.
should be:
...of access the user partmusic has for the database music.

change:

while($row = @ mysql_fetch_array($result))

to:

while($row = @ mysql_fetch_array($result, MYSQL_ASSOC))

(add the missing MYSQL_ASSOC) as is shown in the full code on p. 406

“About the Authors”: Change “England” to “Britain” and “between civilizations” to “among civilizations.”