Introduction to inserting, editing & deleting records in a MySQL database table using PHPMyAdmin

In this tutorial you will learn how to insert, edit or delete records into a table using PHPMyAdmin. Once a table is successfully created, we can insert, edit or delete a record using MySQLAdmin. The following steps will explain how to handle insert, edit and delete operations on records.

Steps for insert, edit & delete operations using PHPMyAdmin

1. To insert a record into a table, click the 'Insert' button as indicated by the arrow in the figure below:

   
   Figure showing MySQL Database in PHPMyAdmin interface.

2. Next step is to enter the values for each fields and click the 'Go' button to insert the record into the table.

   
   Figure showing PHPMyAdmin interface for Insert operation.

3. The screen after successful insertion is shown as below, now click the 'Browse' button to view the list of records in the table.

   
   Figure showing PHPMyAdmin interface for successful insert.

4. To edit a particular record use the edit button, make the necessary changes to the selected record and then click the 'Go' button to save the changes to the database.

   
   Figure showing PHPMyAdmin interface for Edit operation.
5. To Delete a particular record, first select the record and click the 'Delete' button. To delete more than one record, use the checkbox to select them and then click the 'Delete' button.

Deletion of a single record:


Figure showing PHPMyAdmin interface for Delete operation.

Deletion of a list of selected records (for more than one record):


Figure showing PHPMyAdmin interface for Multiple record Deletion operation.

Confirmation of deletion:


Figure showing PHPMyAdmin interface for confirmation of deletion.

That's it you've learnt how to perform various operations like insert, edit and delete in MySQL using PHPMyAdmin.

Absolutely FREE Web Templates
Check out these quality free web templates and download them without any registration or sign-up!

FREE Web Design Guide
From web design tips & ideas to HTML, CSS Styles, Fireworks & Dreamweaver you'll find all you need to know about effective web site design right here!

Quality Dreamweaver Templates
Professional quality dreamweaver templates in over 20 categories, starting at just $9.95! Instant download & easy customization