Errata
MySQL Crash Course · ISBN 0672327120 · 23 corrections
Initial printing
| 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 |
| 44 | Entire page | This page should have been blank, and is a duplicate of the next page, page 45 |
| 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 | Paragraph “To download a copy”, words: it clearly explained | Should be: it is clearly explained |
| 282 | Obtaining the Software, second paragraph, first line: go towww.dev.mysql.com | Should be: go to dev.mysql.com |
| 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 |