-
Book Overview & Buying
-
Table Of Contents
Mastering phpMyAdmin 2.11 for Effective MySQL Management - Third Edition
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!
Change the font size
Change margin width
Change background colour