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:
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." |