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:

Image General database properties

Image Creating, modifying, and dropping databases

Image Obtaining database metadata

7.1 Database ...

Get MySQL 5.0 Certification Study Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.