Chapter 2. Creating and Managing Databases, Tables, and Indexes

The phrases in this chapter focus on creating and managing the structures in MySQL that, from a logical point of view, store and organize the data that lives on the MySQL server.

Not all readers are familiar with the basics of how MySQL models the data that it stores, so we will also take a five-minute detour to discuss the basics of databases, tables, columns, and indexes.

Quick Guide: Databases, Tables, Columns, and Indexes

The basic model MySQL uses for structuring the data it stores is fairly simple to understand—but, perhaps, only when you already understand it. The basic model is as follows:

  • The MySQL server contains one or more databases.

  • Each database has a name and contains one ...

Get MySQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.