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:	Which function makes the server do more work: mysql_store_result() or mysql_use_result()?
A1:	mysql_use_result() is harder on the server because the server has to store the entire resultset while the client retrieves them a row at a time. In contrast, mysql_store_result() returns the whole resultset to the client in one go.
2:	True or False: When connected to a MySQL database using mysql_real_connect(), you can still change the default database.
A2:	True. Use mysql_select_db().
3:	True or False: You have to use make to create C programs for ...