Sams Teach Yourself MySQL in 21 Days, Second Edition

Workshop

The quiz and exercises are provided to help you solidify your understanding of the material covered today. Try to understand the quiz and exercise answers before continuing to tomorrow's lesson.

Quiz

1:	True or False: mysqlimport does the same thing as LOAD DATA INFILE.
A1:	True. LOAD DATA INFILE is the SQL version and almost identical in operation to the mysqlimport utility.
2:	True or False: mysqlimport does the same thing as mysql when used in batch mode.
A2:	False. mysqlimport expects “raw” data in some text-delimited form, whereas mysql used in batch mode processes SQL statements read from a text file.
3:	Assume that you have a table products that looks like this: +------+----------------+-------+ | id | product_name | price | +------+----------------+-------+ ...