Knowledgebase

Becoming familiar with databases in phpMyAdmin

This tutorial is going to help you become more familiar with databases and phpMyAdmin. We are going to assume that you are logged into phpMyAdmin.

The main screen is divided into two screens. In the blue section on the left you can see any databases you already have listed and you have direct access to them. A database consists of one or more tables and it is in the tables that database information is recorded. In the blue screen below any databases you have, it will list any tables in those databases.

If you click on a database name on the left hand side, the right hand screen opens up with information about that the tables contained in that database as well as giving you the option of performing several actions. In the action section it allows you the following actions you can perform on each individual table.

You can browse a table to see the individual records, see the structure of a table and perform certain actions. You can search for specific keywords in a table, insert new rows (or fields) in the table, delete the contents of a table or with the big red X you can delete an entire table completely.

There is a list of action links at the top of the window:

  • Structure in the upper left corner is to view the database structure.
  • SQL will open a SQL query window for entering direct queries to the database.
  • Search which you can click to perform a search.
  • Query which also opens a SQL query window but provides an easier step-by-step way to make queries.
  • Export which you can use to export databases to your local computer.
  • Import will import previously exported databases.
  • Operations can do a number of other operations like creating new tables and copying or renaming databases.

If you return to the blue section and click on a table name, the white screen will now show you the structure of the database table. It will list all the tables fields along with the type of field, attributes, and other properties. If you scroll down it will tell you which field is the primary key field. It provides lots of other information about the table and has the same action links at the top of the screen that the database did.

In the blue screen, right below the phpMyAdmin name there is a row of icons. If your want further help with SQL you can click the icon that is for documentation. It is a box with SQL inside it. The box with the question mark will get you assistance with phpMyAdmin by clicking on it. The middle box with the red SQL is another way of opening the SQL query window. The icon with the exit and arrow will log you out of phpMyAdmin. Clicking on the house returns you to the main screen.

You should be more familiar with phpMyAdmin and what you can use it to do. Be sure to check out the other tutorials in the series for more detailed instructions on specific actions.

For additional assistance, contact us by submitting a support ticket.

Was this answer helpful?

Add to Favourites Add to Favourites

Print this Article Print this Article

Quick Navigation
Language:

Client Login:

Email

Password

Remember Me