Becoming Familiar with Databases in phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin. Now let’s familiarize ourselves with databases and phpMyadmin.

  1. 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
  2. From here we can see more information about the tables contained in the database, as well as perform several actions.phpma-familiar-frame03_1
  3. We can Browse a table to see the individual records.phpma-familiar-frame04_1
  4. We can see the Structure of a table and perform certain actions.phpma-familiar-frame05_1
  5. We can Search through a table for specific keywords.phpma-familiar-frame06_1
  6. We can Insert new rows (or fields) into a table.phpma-familiar-frame07_1
  7. We can Empty  (or delete) the contents of a table.phpma-familiar-frame08_1
  8. Or we can Delete (or drop) an entire table altogether.phpma-familiar-frame09_1
  9. We can alternatively click here to view the database Structure.phpma-familiar-frame10_1
  10. We can open an SQL Query window for entering direct queries to the database.phpma-familiar-frame11_1
  11. We can click here to perform a Search.phpma-familiar-frame12_1
  12. This also opens a SQL Query window but provides an easier step-by-step way to make queries.phpma-familiar-frame13_1
  13. We can Export databases to our local computer.phpma-familiar-frame14_1
  14. We can Import previously exported databases.phpma-familiar-frame15_1
  15. … and we can perform a number of other operations like creating new tables, copying or renaming databases from here.phpma-familiar-frame16_1
  16. Now let’s look at the structure of the details table.phpma-familiar-frame17_1
  17. The structure of the details table lists all the table’s fields, along with the type of field, etc.phpma-familiar-frame18_1
  18. Here it tells us that the id field is the Primary Key field.phpma-familiar-frame19_1
  19. If you want further help with SQL, you can click here…..phpma-familiar-frame22_1
  20. … or help with phpMyAdmin, you can click here.phpma-familiar-frame23_1
  21. Clicking here is another way of opening the SQL query window.phpma-familiar-frame24_1
  22. … and clicking here logs you out of phpMyAdmin.phpma-familiar-frame25_1

 

Be Sociable, Share!
    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