MySQL 5.0 Certification Study Guide

2017-07-07 02:10:07

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 "table" can mean either "base table" (a table that contains data) or "view" (a virtual table). In this chapter, views do not enter the discussion, so "table" means "base table." Views are covered in Chapter 14, "Views."

Категории