Knowledgebase

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.

  • 1 Users Found This Useful

Was this answer helpful?

Related Articles

Creating Tables in a Database with phpMyAdmin

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

Deleting Tables in a Database with phpMyAdmin

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

Inserting Fields into Database Tables with phpMyAdmin

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

Modifying Fields in Database Tables with phpMyAdmin

To modify fields in database 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...

Powered by WHMCompleteSolution