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 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.