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

Renaming Database Tables with phpMyAdmin

To rename database tables in phpMyAdmin, first login to phpMyAdmin and then follow this guide. 1....

Inserting Fields into Database Tables with phpMyAdmin

To insert fields into database tables in phpMyAdmin, first login to phpMyAdmin and then follow...

Deleting Fields from Database Tables with phpMyAdmin

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

Creating Tables in a Database with phpMyAdmin

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

Modifying Fields in Database Tables with phpMyAdmin

To modify fields in database tables in phpMyAdmin, first login to phpMyAdmin and then follow this...