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.

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.

 

frame02_1.png

 

Click the database name here.

 

frame03_1.png

 

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

We can Browse a table to see the individual records.

 

frame04_1.png

 

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

 

frame05_1.png

 

We can Search through a table for specific keywords.

 

frame06_1.png

 

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

 

frame07_1.png

 

We can Delete the contents of a table.

 

frame08_1.png

 

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

 

frame09_1.png

 

We can alternatively click here to view the database Structure.

 

frame10_1.png

 

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


frame11_1.png

 

We can click here to perform a Search.


frame12_1.png

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

 

We can Export databases to our local computer.


frame14_1.png

 

We can Import previously exported databases.


frame15_1.png

 

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


frame16_1.png

 

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


frame17_1.png

 

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


frame18_1.png

 

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


frame19_1.png

 

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


frame22_1.png

 

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


frame23_1.png

 

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


frame24_1.png

 

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


frame25_1.png

 

Let's return to the main screen.


frame26_1.png

 

This is the end of the tutorial. You should now be more familiar with phpMyAdmin, and what you can use it to do. Be sure to check out our other tutorials for more detailed instructions.

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk