MySQL Crash Course

  • ISBN: 0672327120
  • Pages: 256
  • Publisher: Sams - December 15, 2005

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
Error: Should be: go to
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

Back to Book Information