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 go back to the Database
view for marc_book and request the creation of another table with three columns as indicated in the following screenshot:
Using the same techniques used when creating the first table, we type this in:
As we have three columns or less, the display is now in vertical mode (refer to the Vertical mode section in Chapter 5 for more ...
Get Mastering phpMyAdmin 3.4 for Effective MySQL Management now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.