Chapter 10. Working with Your MySQL Database
In this chapter, we discuss Structured Query Language (SQL) and its use in querying databases. You continue developing the Book-O-Rama database by learning how to insert, delete, and update data, and how to ask the database questions.
Key topics covered in this chapter include
What is SQL?
Inserting data into the database
Retrieving data from the database
Joining tables
Using subqueries
Updating records from the database
Altering tables after creation
Deleting records from the database
Dropping tables
We begin by describing what SQL is and why it's a useful thing to understand.
If you haven't set up the Book-O-Rama database, you need to do that before you can run the SQL queries in this chapter. Instructions for ...
Get PHP and MySQL Web Development, Third 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.
