Chapter 7. Databases

Databases contain tables, which are used for storing data. Databases also contain related data-manipulation objects such as stored routines or triggers. This chapter discusses each of the SQL statements that are used in MySQL to define the structural characteristics of your databases. It covers the following exam topics:

• General database properties

• Creating, modifying, and dropping databases

• Obtaining database metadata