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 |