Becoming Familiar with Databases in phpMyAdmin

Reading Time: 2 minutes

Tutorial: phpMyAdmin

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

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

 From here we can see more information about the tables contained in the database, as well as perform several actions.phpma-familiar-frame03_1 We can Browse a table to see the individual records.phpma-familiar-frame04_1 We can see the Structure of a table and perform certain actions.Sphpma-familiar-frame05_1 We can Search through a table for specific keywords.phpma-familiar-frame06_1Step 6:  We can Insert new rows (or fields) into a table.phpma-familiar-frame07_1We can Empty  (or delete) the contents of a table.phpma-familiar-frame08_1Or we can Delete (or drop) an entire table altogether.phpma-familiar-frame09_1We can alternatively click here to view the database Structure.phpma-familiar-frame10_1We can open an SQL Query window for entering direct queries to the database.phpma-familiar-frame11_1We can click here to perform a Search.phpma-familiar-frame12_1This also opens a SQL Query window but provides an easier step-by-step way to make queries.phpma-familiar-frame13_1We can Export databases to our local computer.phpma-familiar-frame14_1We can Import previously exported databases.phpma-familiar-frame15_1and we can perform a number of other operations like creating new tables, copying or renaming databases from here.phpma-familiar-frame16_1Now let’s look at the structure of the details table.phpma-familiar-frame17_1The structure of the details table lists all the table’s fields, along with the type of field, etc.phpma-familiar-frame18_1Here it tells us that the id field is the Primary Key field.phpma-familiar-frame19_1If you want further help with SQL, you can click here…..phpma-familiar-frame22_1or help with phpMyAdmin, you can click here.phpma-familiar-frame23_1Clicking here is another way of opening the SQL query window.phpma-familiar-frame24_1

  1. … and clicking here logs you out of phpMyAdmin.phpma-familiar-frame25_1

 

Refer a friend and receive hosting credit