As much as I'd like to be able to produce completely error free books, the reality of the computer publishing industry is that the pace at which books must be written and released makes this very difficult. And regretfully, my own books do have sporadic mistakes and typos scattered throughout them.
For the benefit of my readers, here is a current errata for MySQL Crash Course. Feel free to print this page for future reference.
And as always, if you come across errors that I do not know about, please let me know. I'll make sure they are added to this list, and will try to have them corrected in future reprints.
Page 3
Location: Final line: provide clear
Error: Should be: provides clear
Page 17
Location: Second paragraph, second line: mysql -help
Error: Should be: mysql --help
Page 33
Location: Analysis block, second line:instj34ructs
Error: Should be: instructs
Page 45
Location: First paragraph, third line: t able's
Error: Should be: table's
Page 78
Location: First input block, third line of code
Error: The characters 77 at the end of the line are extraneous and should not be there.
Page 114
Location: Output block, first line
Error: The characters j115 at the start of the line are extraneous and should not be there.
Page 165
Location: First line: a single row
Error: Should be: a single column
Page 173
Location: INPUT block, final line of code
Error: Contains an extraneous " after word bait
Page 181
Location: TIP, second paragraph, first line: as is usually is
Error: Should be: as it usually is
Page 183
Location: TIP, second line: possessing
Error: Should be: processing
Page 189
Location: Second tip, first line: UPDATE
Error: Both should be: DELETE
Page 201
Location: Last line: same tables
Error: Should be: sample tables
Page 215
Location: OUTPUT block
Error: The output is missing the first column, order_num. Running this SQL statement will return 5 columns, not 4 as shown.
Page 232
Location: Input block, second to last line: SELECT ordernum
Error: Should be: SELECT order_num
Page 242
Location: Input block, trigger example
Error: This statement was allowed when MySQL 5 first shipped, but has subsequently been disallowed. SELECT may now only be used in triggers if used in conjunction with INTO.
Page 268
Location: First INPUT block, text: beforta
Error: Should be: bforta
Page 269
Location: First INPUT block, text: beforta
Error: Should be: bforta
Page 271
Location: TIP, final line, text: beforta
Error: Should be: bforta
Page 282
Location: Obtaining the Software, second paragraph, first line: go towww.dev.mysql.com
Error: Should be: go to dev.mysql.com
Location: Paragraph "To download a copy", words: it clearly explained
Error: Should be: it is clearly explained
Page 290
Location: Creating the Sample Tables
Error: Before running the scripts you will need to create a database. To create a database named crashcourse (as used in this book), use the MySQL command: CREATE DATABASE crashcourse;
Page 291
Location: Third numbered step, second line, first word: lint
Error: Should be: line