Errata
The following items apply to the first edition (USA, UK and Canada).
- Chapter 2, Page 31
In the section "Altering Table Names", the description should state: "The following example demonstrates by renaming table airport to cities". - Chapter 3, Page 67
The second example for Boolean searches is missing. The missing example is shown below:
mysql> SELECT Title, Author FROM books WHERE MATCH (Synopsis) AGAINST
('+romance -teenage -period' IN BOOLEAN MODE);
Empty set (0.00 sec)
- Chapter 7, Page 173
In the section "Triggers and More Complex Applications", the final example should state: "20 seats available in Silver class at a base price of $50".