II. Running SQL Queries on a Database with phpMyAdmin
III. Searching Through a Database with phpMyAdmin
IV. Creating Tables in a Database with phpMyAdmin
V. Deleting Tables from a Database with phpMyAdmin
VI. Importing Databases and Tables with phpMyAdmin
VII. Exporting Databases and Tables with phpMyAdmin
VIII. Renaming Database Tables with phpMyAdmin
IX. Copying a Database Table with phpMyAdmin
X. Inserting Fields into Database Tables with phpMyAdmin
XI. Modifying Fields in Database Tables with phpMyAdmin
XII. Deleting Fields from Database Tables with 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.
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. We can see the Structure of a table and perform certain actions.S We can Search through a table for specific keywords.Step 6: We can Insert new rows (or fields) into a table.We can Empty (or delete) the contents of a table.Or we can Delete (or drop) an entire table altogether.We can alternatively click here to view the database Structure.We can open an SQL Query window for entering direct queries to the database.We can click here to perform a Search.This also opens a SQL Query window but provides an easier step-by-step way to make queries.We can Export databases to our local computer.We can Import previously exported databases.and we can perform a number of other operations like creating new tables, copying or renaming databases from here.Now let’s look at the structure of the details table.The structure of the details table lists all the table’s fields, along with the type of field, etc.Here it tells us that the id field is the Primary Key field.If you want further help with SQL, you can click here…..or help with phpMyAdmin, you can click here.Clicking here is another way of opening the SQL query window.