Books

MySQL Crash Course

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 17

Page 33

Page 45

Location: First paragraph, third line: t able'sError: Should be: table's

Page 78

Location: First input block, third line of codeError: The characters 77 at the end of the line are extraneous and should not be there.

Page 114

Location: Output block, first lineError: The characters j115 at the start of the line are extraneous and should not be there.

Page 165

Location: First line: a single rowError: Should be: a single column

Page 173

Location: INPUT block, final line of codeError: Contains an extraneous " after word bait

Page 181

Location: TIP, second paragraph, first line: as is usually isError: Should be: as it usually is

Page 183

Location: TIP, second line: possessingError: Should be: processing

Page 189

Location: Second tip, first line: UPDATEError: Both should be: DELETE

Page 201

Location: Last line: same tablesError: Should be: sample tables

Page 215

Location: OUTPUT blockError: 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 ordernumError: Should be: SELECT order_num

Page 242

Location: Input block, trigger exampleError: 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: befortaError: Should be: bforta

Page 269

Location: First INPUT block, text: befortaError: Should be: bforta

Page 271

Location: TIP, final line, text: befortaError: Should be: bforta

Page 282

Location: Obtaining the Software, second paragraph, first line: go towww.dev.mysql.comError: Should be: go to dev.mysql.comLocation: Paragraph "To download a copy", words: it clearly explainedError: Should be: it is clearly explained

Page 290

Location: Creating the Sample TablesError: 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: lintError: Should be: line