Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

Creating Our First Table


Now that we have a new database, it's time to create a table in it. The example table we will use is the familiar book table.

Choosing the Fields

Before creating a table, we should plan the information we want to store. This is usually done during database design. In our case, a simple analysis leads us to the following book-related data we want to keep:

  • International Standard Book Number (ISBN)

  • Title

  • Number of pages

  • Author identification

For now, it is not important to have the complete list of fields (or columns) for our book table; we will modify it by prototyping the application and refine it later. At the end of the chapter, we will add a second table, author, containing information about each author.

Table Creation

We have chosen our table name and we know the number of fields. We enter this information in the Create new table dialog and click Go to start creating the table:

We then see a panel specifying field information. Since we asked for four fields, we get...