Go to the previous topic.    Go to the next topic.

Building Tables

Tables are the basic building blocks of databases. They consist of columns (or fields) and rows. Each row is a single data record; for example, if you had a table for storing customer names, each row might contain a customerID field, a first_name field and a last_name field. You use phpMyAdmin to create, alter and delete records from tables.

Subtopics:

Creating table structure

Inserting rows

Setting column indexes

Altering table structure

Deleting records

Emptying tables

Dropping tables