O'Reilly logo

MySQL 5.0 Certification Study Guide by Carsten Pedersen, Stefan Hinz, Paul DuBois

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

Image General table properties

Image Creating, altering, and dropping tables

Image Emptying table contents

Creating and dropping indexes

Obtaining table and index metadata

The term ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required