O'Reilly logo

Mastering phpMyAdmin 3.1 for Effective MySQL Management by Marc Delisle

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. We click on marc_book in the navigation panel, and request the creation of another table with three fields as indicated in the following screenshot:

Creating an additional table

Using the same techniques used when creating the first table, we type this in:

Creating an additional table

As we have three fields or less, the display is now in vertical mode (see the Vertical ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required