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 an Additional Table


In our (simple) design, we know that we need another table: the author table. The author table will contain:

  • Author identification

  • Full name

  • Phone number

To create this table, we must go back to the Database view in the left panel. We click on marc_book in the left panel, and request the creation of another table with three fields:

Using the same techniques used when creating the first table, we get:

Since we have three fields or less, the display is now in vertical mode (more details on this in Chapter 6, Vertical Mode section).

Here the field name id, which is our primary key in this new table, relates to the author_id field from the book table. After saving the table structure, we enter some data for authors 1 and 2. Use your imagination for this!