phpMyAdmin Tutorials

Table Management

phpMyAdmin is intended to handle the administration of MySQL over the web.

Access phpMyAdmin

To access phpMyAdmin, follow the directions listed on the Access phpMyAdmin tutorial. Then continue with the directions below to restore a database.

Insert Table Data

In the phpMyAdmin window that appears, click the name of your database in the left pane (just under the icons). You can insert data into a table by either clicking the insert icon (next to the table name in the right frame) or by clicking the table name (under the database name in the left frame) and selecting the Insert tab.

This will bring up the insert page.

Insert this information into the value text area next to each field

Name - Your Name
Age - Your Age
Zip - Your Zip (if it applies)

After filling in the data into the fields provided, click Go. The information has now been inserted into the table. You should see a MySQL Query like that below.

View Table Content

You can view data in a table by either clicking the browse icon (next to the table name in the right frame) or by clicking the table name (under the database name in the left frame) and selecting the Browse tab.

Search Table

You can search data in a table by either clicking the search icon (next to the table name in the right frame) or by clicking the table name (under the database name in the left frame) and selecting the Search tab.

Remove Table Content

You can remove data from a table by either clicking the empty icon (next to the table name in the right frame) or by clicking the table name (under the database name in the left frame) and selecting the Empty tab.