Becoming Familiar with Databases in phpMyAdmin

To familiarise yourself with databases in phpMyAdmin, first login to phpMyAdmin and then follow this guide.

1. From the first screen, you will have access to your databases, which are listed on the left.

2. Clicking a database name will show a list of tables in the database on the left and more detailed information on the right.

3. In the Action section, you can click 'Browse' to see the individual records in a table.

4. Click 'Structure' to view a tables structure and perform several actions.

5. Click 'Search' to search using specific keywords.

6. Click 'Insert' to add new rows (or fields) to the table.

7. Click 'Empty' to delete the contents of a table.

8. Click 'Drop' to delete the whole table and its contents.

9. Click a table on the left to view the structure of the table's fields.

Note: For further help with phpMyAdmin click the 'Question Mark' icon on the left hand side.

Note: For further help with SQL click the 'SQL' icon on the left hand side.

Was this answer helpful?

 Print this Article

Also Read

Creating Tables in a Database with phpMyAdmin

To create tables in a database in phpMyAdmin, first login to phpMyAdmin and then follow this...

Exporting Databases and Tables with phpMyAdmin

To export databases and tables in phpMyAdmin, first login to phpMyAdmin and then follow this...

Importing Databases and Tables with phpMyAdmin

To import databases and tables in phpMyAdmin, first login to phpMyAdmin and then follow this...

Deleting Fields from Database Tables with phpMyAdmin

To delete fields from database tables in phpMyAdmin, first login to phpMyAdmin and then follow...

Deleting Tables in a Database with phpMyAdmin

To delete tables in a database in phpMyAdmin, first login to phpMyAdmin and then follow this...