Appendix A. A Brief MySQL Tutorial
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 doing—the 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 complex—you 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
Getting Started
Before you can start running the examples ...
Get MySQL® Phrasebook 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.
