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: mysqldump can only create output as SQL.

A1: False. mysqldump --tab creates a file of SQL for table creation and a text file of character-delimited data.
2:

True or False: You cannot insert data into a table that has been compressed with myisampack.

A2: True. Tables compressed with myisampack are read-only.
3:

True or False: Once you set a password for a MySQL user account, it's impossible for that user to connect to MySQL without typing a password (using one of the client utilities).

A3: False. You can place the user's password ...

Get Sams Teach Yourself MySQL in 21 Days, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.