databases in phpMyAdmin
databases in 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
img 15 37 43

Click the database name here
img 15 37 43

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 5

We can see the Structure of a table and perform certain actions
img 15 38 40

We can Search through a table for specific keywords
img 15 38 40

We can Insert new rows (or fields) into a table
img 15 38 40

We can Empty the contents of a table
img 15 38 40

Or we can Delete (or drop) an entire table altogether
img 15 38 40

We can alternatively click here to view the database Structure
img 15 41 50

We can open a SQL Query window for entering direct queries to the database
img 15 42 18

We can click here to perform a Search
img 15 42 49

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

We can Export databases to our local computer
img 15 44 07

We can Import previously exported databases
img 15 44 43

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

Now let’s look at the structure of the details table
img 15 46 04

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

Here it tells us that the id field is the Primary Key field
img 15 46 04

….. and clicking here logs you out of phpMyAdmin

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

Leave a Reply