Becoming Familiar with Databases in phpMyAdmin Print

  • 2

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?

« Back

Powered by WHMCompleteSolution