MySQL Phrasebook

In this appendix you're going to briefly walk through the entire process of creating and using a database, from designing tables and creating users to adding indexes and querying tables. The focus is on a mix of explaining and doingthe intent is to quickly get you productive with MySQL.

The database you'll build in this appendix will be used to store information about books and book loans from a tiny library. The database won't be too complexyou will just store the essential pieces of data such as

• The title, condition, and author of books in the library

• The names and email addresses of people who borrow books

• The details of when books were loaned to people