O'Reilly logo

Mastering phpMyAdmin 3.3.x 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 our first table

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

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's not important to have the complete list of fields (or columns) for our book table. We will modify it by prototyping the application now and refining it later. At the end of the chapter, we will add a second table, author, containing information about each author.

Creating a table

We have ...

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