Errata for the MySQL 4 Certification Study Guide

• Although reading the exam content layout will soon make it apparent, the layout of the book does not make a clear distinction between the chapters referring to the Core exam and the Professional exam. Chapters 1-9 cover the contents for the Core exam; chapters 10-16 contain the content related to the Professional exam.
• Page 12: The world database which is used as an example in several different places in the book may be downloaded from http://dev.mysql.com/doc/.
• Page 19: The "n" which appears under the first bullet point should also be a bullet point.
• Page 37: 2nd line from the bottom: Country should read CountryCode.
• Page 45: The first two shell> examples: replace --fields-terminated-by with fields-enclosed-by.
• Page 69: In the CREATE TABLE statement: Delete the comma in CountryCode CHAR(3) NOT NULL,
• Page 90, first line: TIMESTAMP values are stored as UTC, not the server's local timezone.
• Page 99, 4th bullet point: "Handing" should be "Handling"
• Page 100: In the table of conversions, 5th row, the INT and DECIMAL conversions should both read "1978" rather than "1970".
• Page 128: Answer 57 is correct. However, several recent versions of MySQL contain a bug affecting the interpretation of date value where the year is specified using only two digits and with month and date parts which are both 0 (the value ends on "00-00"). In this specific case, the server may force the initial two digits of the year to be stored as "00" rather than "20".
• Page 131, answer 69: The parenthesis should read: "(Although creation is declared as NULL, MySQL will never assign a NULL value to a TIMESTAMP column, but use the "zero" value instead.)
• Page 139, answer 110: The first statement should read: SHOW TABLES LIKE '%test%';
• Page 152, 2nd line: (1+2+8) should read (1+2+4).
• Page 163: Section 5.7, 3rd paragraph: Change "replace the first instance of UNION with UNION ALL" to "replace all instances of UNION with UNION ALL"
• Page 171, question 13b: Remove "the employees with".
• Page 172, question 14: "How many rows will the following statements return?" should read "What will be the results of the following queries?"
• Page 178, answer 12c: Remove "AS Species"; in the rest of the text, "species" should appear with lowercase 's'.
• Page 180: In answer 16, The first SELECT statement shown should include the keyword 'ALL' for both UNION statements.
• Page 200: After "The other aggregate functions always ignore NULL values", add: ", except where the values being aggregated are all NULL". In the example immediately following, the output should be (9, 7, NULL, NULL) rather than (9, 7, 0, 0). On page 201, delete the paragraph "Note that SUM()..." just before the heading of section 6.7.
• Page 218: The result set shown on lines 3-7 should include the name column, i.e.

  +---------+----------+
  | name    | COUNT(*) |
  +---------+----------+
  | Lennart |        4 |
  +---------+----------+
  

• Page 265, first bullet point: "CountryLanguage and CountryLanguage tables." should read "CountryLanguage and Country tables."
• Page 282, Question 10: This question/answer pair contains several errors. Both should be struck from the text.
• Page 283, answer 11: The answer does not follow the requirement that clients without projects should be shown. Adding OR p.id IS NULL to the WHERE clause will resolve this and also show the line (125, "Nittboad Inc", NULL, NULL, NULL) in the result.
• Page 283-285, Questions 12-16: In the project table in the row where pid is 10020, the value of id should be 110 (rather than 100).
• Page 291, answer 6: "WHERE START BETWEEN..." should read "WHERE p.start BETWEEN..."
• Page 292, Answer 10: This question/answer pair contains several errors. Both should be struck from the text.
• Page 307, third bullet point: , line 1: "('/')" should be "('\')".
• Page 452, lines 7 and 8 from the bottom: Neither command should have the db_name argument.
• Appendix B: Several minor changes have been made in the on-line version of the MySQL Certification Candidate Guide, to reflect the fact that the Study Guide is now available.

If you believe you have found further errors in the MySQL Certification Study Guide, please send an e-mail to certification@mysql.com or use our Contact Form.