Chapter 8. Tables and Indexes


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



MySQL 5 Certification Study Guide
MySQL 5.0 Certification Study Guide
ISBN: 0672328127
EAN: 2147483647
Year: 2006
Pages: 312

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net