Data Management In MySQL Databases Using phpMyAdmin

By: Joseph de Souza

   PhpMyAdmin provides several functions to manage data in MySQL databases. This part deals with inserting, editing or deleting data from a MySQL database using phpMyAdmin. The first part of the tutorial explains how to create new MySQL databases as well as users and assigning privileges to users.

Deleting Or Editing Data From MySQL Database Using phpMyAdmin

   PhpMyAdmin can be used to edit or delete data from a MySQL database. After logging in we have to select the database for which we want to edit or delete data.
   Once we have opened a table of the MySQL database for browsing, editing or deleting a row or rows, multiple rows of data of the selected table will be displayed as shown in the screenshot below.
select a MySQL database table for Browsing, Editing or Deleting rows

   To edit a single row we have to click on the pencil icon besides that particular row and for deleting that row we have to click on the red X icon besides that row.
   To edit or delete multiple rows we have to select the required rows by clicking on the check boxes besides them and then click on the pencil icon or on the red X icon respectively at the bottom for editing or deleting as shown in the screenshot below.

Editing or Deleting rows in a MySQL database using phpMyAdmin

Inserting Data In A MySQL Database Using phpMyAdmin

   phpMyAdmin can also be used for adding rows to the database table. Instead for opening the table in browse mode as seen earlier where we have selected the browse mode and then proceeded to edit or delete rows, we have to open the table in Insert mode and then add rows to the selected table.
selecting a MySQL table for insert a row of data

      To enter a new row of data we have to enter the values of each field next to it as indicated in the screenshot below. After entering all the fields click on the GO button.

Inseting a data row in a MySQL database using phpMyAdmin

About The Author

Joseph de Souza is a leading Freelance SEO consultant and Web developer in Goa, India with more than 15 years of experience in internet marketing.
He has a proven track record and has has helped several companies increase their traffic many times over and thereby increase their revenue and profits.
Besides English, Joseph has also successfully optimized two German language websites and a Danish language website and obtained outstanding results.
[Read full bio]


Like Infosolutions Goa on Facebook