Chapter 4. Creating and Browsing Tables

Having seen the overall layout of phpMyAdmin, we are ready to create a database, create our first table, insert some data into it, and browse it. These first steps are intentionally simple, but they will give you the foundation on which more complex operations will be achieved later. At the end of the chapter, we will have at our disposal the two basic tables on which the remaining exercises are based.

Creating a database

Before creating a table, we must ensure that we have a database for which the MySQL server's administrator has given us the CREATE privilege. The following possibilities exist:

  • The administrator has already created a database for us, and we see its name in the navigation panel; we don't have ...

Get Mastering phpMyAdmin 3.4 for Effective MySQL Management now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.