Get 90% OFF the first month of your service

USE COUPON CODE: Q32018

T&Cs Apply

Becoming familiar with databases and phpMyAdmin

This tutorial will show you how to become familiar with databases and 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_140

Click the database name here

frame03_161

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_166

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

frame05_162

We can Search through a table for specific keywords

frame06_157

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

frame07_160

We can Delete the contents of a table

frame08_151

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

frame09_151

We can alternatively click here to view the database Structure

frame10_147

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

frame11_145

We can click here to perform a Search

frame12_141

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

frame13_138

We can Export databases to our local computer

frame14_134

We can Import previously exported databases

frame15_129

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

frame16_124

Now let’s look at the structure of the details table

frame17_128

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

frame18_121

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

frame19_124

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

frame22_117

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

frame23_117

Clicking here is another way of opening the SQL query window

frame24_114

….. and clicking here logs you out of phpMyAdmin

frame25_114

Let’s return to the main screen

frame26_111

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