NOTE: Please go to the MySQL web site to obtain the latest versions of the MySQL database.

Hour 1: Introducing MySQL

• On page 14, the second Java driver is called Resin, not Reisin.

Hour 2: Understanding Database Terminology

• On page 22, in the last sentence of the second paragraph, insert "multi-column" between "provide" and "indexes", so it reads "...that provide multi-column indexes, which are...".

Hour 4: Using the MySQL Client

• On page 44, the second example of a quoted string is missing the end quote. It should read:
  

  "O'Connor said \"Boo\""
  		

• In the section "Working with the MySQL Administration Tools", the assumption is that you are using the default installation and have not yet created a root user password. If you have an actual account created, you should add the username and password to your mysqladmin or mysqldump commands. In Hour 6, when you're doing things "for real", the full command is shown.
  

  mysqladmin -u [your username] -p[your password] [command]
  mysqldump -u [your username] -p[your password] [command]
  		

• On page 51, the answer to question #1 is:
  

  mysqladmin create MyDB
  		

Hour 5: Securing MySQL

• On page 56, in the the two sample connection attempts, using the username of joe, replace "test" with "myDB". The point is that the user was trying to connect to the myDB database, not the test one.

  #prompt> /usr/local/bin/mysql/bin/mysql -h localhost -u joe -pabc123 myDB
  		

Hour 9: Populating Your Database Tables

• On page 99, the first line should read "Using the master_name table in the contactDB database..." not "connectDB database".

Hour 10: Selecting Data From Your Tables

• On page 116, in the sample selection of 3890 rows, the 3890th row should also have the string "I Love MySQL" in the string_field column.

Hour 15: Using MySQL String Functions

• This isn't really errata, but at the end of page 175, there is extra bold in the results table display, on the words 'MYSQL' and 'mysql'. It's just a printing thing, don't worry about it.

Hour 19: Practical Transaction Usage

• This isn't really errata, but in the middle of page 218, the first example for mysql_convert_table_format lost its bold style. It's just a printing thing, don't worry about it.

Hour 21: Backing Up and Restoring Your Database

• This isn't really errata, but on pages 240 and 241, some of the sample commands lost their bolding. It's just a printing thing, don't worry about it.

Hour 24: Using MySQL with PHP

• On pages 280-282, when using form submissions, these scripts assuming that register_globals is on in your version of PHP. If it is not, use $_POST['testField'] in place of $testField in your PHP script.

Appendix D: Practical MySQL/PHP Examples

• This isn't really errata, but on page 320 there is some extra bolding. It's just a printing thing, don't worry about it.
• On pages 327-330, when using form submissions, the script assumes that register_globals is on in your version of PHP. If it is not, use $_POST['op'] in place of $op, $_POST['poll_id] in place of $poll_id, and $_POST['answer_id'] in place of $answer_id in your PHP script.
• On pages 334-335, when using form submissions, the script assumes that register_globals is on in your version of PHP. If it is not, use $_POST['img1'] in place of $img1 in your PHP script.

 

[last updated 2003-09-03]