Becoming Familiar with Databases in phpMyAdmin

 

  1. This tutorial assumes you've already logged in to phpMyAdmin.
  2. Now let's familiarize ourselves with databases and phpmyadmin.
  3. From this phpMyAdmin screen, we have access directly to the database demo1234_members, listed here. A database consists of one or more tables, and it is in the tables that database information is recorded. This particular database has two tables called details and information, and they are listed here. Click the database name just above them.

    phpma-familiar-frame02_1

  4. From here we can see more information about the tables contained in the database, as well as perform several actions.

    phpma-familiar-frame03_1

  5. We can Browse a table to see the individual records.

    phpma-familiar-frame04_1

  6. We can see the Structure of a table and perform certain actions.

    phpma-familiar-frame05_1

  7. We can Search through a table for specific keywords.

    phpma-familiar-frame06_1

  8. We can Insert new rows (or fields) into a table.

    phpma-familiar-frame07_1

  9. We can Empty  (or delete) the contents of a table.

    phpma-familiar-frame08_1

  10. Or we can Delete (or drop) an entire table altogether.

    phpma-familiar-frame09_1

  11. We can alternatively click here to view the database Structure.

    phpma-familiar-frame10_1

  12. We can open an SQL Query window for entering direct queries to the database.

    phpma-familiar-frame11_1

  13. We can click here to perform a Search.

    phpma-familiar-frame12_1

  14. This also opens a SQL Query window, but provides an easier step-by-step way to make queries.

    phpma-familiar-frame13_1

  15. We can Export databases to our local computer.

    phpma-familiar-frame14_1

  16. We can Import previously exported databases.

    phpma-familiar-frame15_1

  17. … and we can perfom a number of other operations like creating new tables, copying or renaming databases from here.

    phpma-familiar-frame16_1

  18. Now let's look at the structure of the details table.

    phpma-familiar-frame17_1

  19. The structure of the details table lists all the table's fields, along with the type of field, etc.

    phpma-familiar-frame18_1

  20. Here it tells us that the id field is the Primary Key field.

    phpma-familiar-frame19_1

  21. If you want further help with SQL, you can click here…..

    phpma-familiar-frame22_1

  22. … or help with phpMyAdmin, you can click here.

    phpma-familiar-frame23_1

  23. Clicking here is another way of opening the SQL query window.

    phpma-familiar-frame24_1

  24. … and clicking here logs you out of phpMyAdmin.

    phpma-familiar-frame25_1

 

Be Sociable, Share!

Published by

Here's 75 % off, Launch a New VPS Today. Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7 Heroic Support