This tutorial assumes you’ve already logged in to phpMyAdmin, now let’s familiarize ourselves with databases and phpmyadmin.
A database consists of one or more tables, and it is in the tables that database information is recorded. From this phpMyAdmin screen, we have access directly to the database demo1234_members, listed here.
– This particular database has two tables called details and information, and they are listed under the Database Name
1. Click the Database Name on the left hand side
2. From here we can see more information about the tables contained in the database, where several Actions can be performed:
– Browse a table to see the individual records
– View the Structure of a table and perform certain actions
– Search through a table for specific keywords
– Insert new rows (or fields) into a table
– Delete the contents of a table
– Drop (or Delete) an entire table altogether
3. You can also view the database Structure, where you can:
– Open a SQL window for entering direct queries to the database
– Perform a Search
– Open a SQL Query window, but provides an easier step-by-step way to make queries
– Export databases to a local computer
– Import previously exported databases
– And a variety of other Operations like creating new tables, copying or renaming databases from here
4. Now let’s look at the structure of the Details table:
5. The structure of the details table lists all the Table Fields, along with the type of field, etc.
6. Clicking on details on the left hand menu – will give you information about the id field is the Primary Key field
7. Under the phpMyAdmin you will find the following icons:
– Home returns you to the main screen
– Log out
– SQL Query window opens up another Query window
– phpMyAdmin Documentation icon offers further assistance with phpMyAdmin.
– the Documentation icon offers further help with SQL.
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