Tables are used for storing data and tables can be indexed to speed up access to their contents. This chapter discusses each of the SQL statements that are used in MySQL to define the structural characteristics of your tables. It covers the following exam topics:
General table properties
Creating, altering, and dropping tables
Emptying table contents
Creating and dropping indexes
Obtaining table and index metadata
The term ...