Chapter 4: Using the Database
In This Chapter
Storing data in the database
Viewing and retrieving data from the database
Updating data
Deleting data
An empty database is like an empty cookie jar — you get nothing out of it. And searching an empty database is no more interesting or fruitful than searching an empty cookie jar. A database is useful only with respect to the information that it holds.
A database needs to be able to receive information for storage and to deliver information on request. For instance, the CustomerOrderInformation
database described in earlier chapters needs to be able to receive the customer and order information, and it needs to be able to deliver its stored information when you request it. If you want to know the address of a particular customer or the date a particular order was made, for example, the database needs to deliver that information when you request it.
Your MySQL database responds to four types of requests:
Adding information: Adding a row ...