Errata for 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.
This title has been printed multiple times, and different errata are available for each. Select the print you have:
- Original printing (256 pages, published December 15, 2005)
- Sixth printing (as per info page) (322 pages, published July 1, 2008)
Original printing (256 pages, published December 15, 2005)
| Page | Location | Correction |
|---|---|---|
| 3 | Final line: provide clear | Should be: provides clear |
| 17 | Second paragraph, second line: mysql -help | Should be: mysql –help |
| 33 | Analysis block, second line:instj34ructs | Should be: instructs |
| 45 | First paragraph, third line: t able’s | Should be: table’s |
| 78 | First input block, third line of code | The characters 77 at the end of the line are extraneous and should not be there. |
| 114 | Output block, first line | The characters j115 at the start of the line are extraneous and should not be there. |
| 165 | First line: a single row | Should be: a single column |
| 173 | INPUT block, final line of code | Contains an extraneous ” after word bait |
| 181 | TIP, second paragraph, first line: as is usually is | Should be: as it usually is |
| 183 | TIP, second line: possessing | Should be: processing |
| 189 | Second tip, first line: UPDATE | Both should be: DELETE |
| 201 | Last line: same tables | Should be: sample tables |
| 215 | OUTPUT block | The output is missing the first column, order_num. Running this SQL statement will return 5 columns, not 4 as shown. |
| 232 | Input block, second to last line: SELECT ordernum | Should be: SELECT order_num |
| 242 | Input block, trigger example | 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. |
| 268 | First INPUT block, text: beforta | Should be: bforta |
| 269 | First INPUT block, text: beforta | Should be: bforta |
| 271 | TIP, final line, text: beforta | Should be: bforta |
| 282 | Obtaining the Software, second paragraph, first line: go towww.dev.mysql.com | Should be: go to dev.mysql.com |
| 282 | Paragraph “To download a copy”, words: it clearly explained | Should be: it is clearly explained |
| 290 | Creating the Sample Tables | 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; |
| 291 | Third numbered step, second line, first word: lint | Should be: line |
Sixth printing (as per info page) (322 pages, published July 1, 2008)
| Page | Location | Correction |
|---|---|---|
| 44 | Entire page | This page should have been blank, and is a duplicate of the next page, page 45 |