How to Use phpMyAdmin and How select, insert, update, delete and drop table

How to Use phpMyAdmin

Through phpMyAdmin, you can perform many operations like insert, select, update, delete and drop in the table. These operations are done through the SQL Queries.

How to Insert in phpMyAdmin

If you want to add the new information to a column then you have to use insert SQL Query.

Step 1 – First you have to click on the SQL Option

Step 2 – Then click on the insert button.

Step 3 – After clicking on the insert button a query of insert will written on the upper block.

Step 4 – Now you have to just put the values of the created column.

The below screenshot shows insert query syntax.

phpMyAdmin Insert
Fig.1 – phpMyAdmin Insert.

How to Update in phpMyAdmin

To change the value of the a particular row you use update query.

Step 1 – First you have to click on the SQL Option

Step 2 – Then click on the update button.

Step 3 – After clicking on the update button a query of update will written on the upper block.

Step 4 – Now you have to just put the new values of a particular column to change and you to specify a particular row in the where clause.

Step 5- Then you have to click on the “go” button. Then the value will be updated.

phpMyAdmin Update Query
Fig.2 – phpMyAdmin Update Query.

How to Select in phpMyAdmin

To selete the data of a particular table.

Step 1 – First you have to click on the Select button.

Step 2 – After clicking on the select button a query of select will written on the upper block.

Step 3 – If you want to select all rows you have to write * otherwise write a column name and table name.

Step 4 – Then you have to click on the “go” button. The row will be selected and show the reseult.

phpMyAdmin Select Query
Fig.3 – phpMyAdmin Select Query.

How to Delete in phpMyAdmin

To Delete the data of a particular table.

Step 1 – First you have to click on the Delete button.

Step 2 – After clicking on the Delete button a query of delete will written on the upper block.

Step 3 – You have to to nput the value column naame and value of the that column name.

Step 4 – Then you have to click on the “go” button. The row will be deleted.

phpMyAdmin Delete
Fig.4 – phpMyAdmin Delete Database.

How to Drop Table in phpMyAdmin

To Drop the table of a particular database.

Step 1 – You have to write the query yourself.

Step 2 – The query is drop table table_name;.

Step 3 – After writing this query you have to click on the go option than query will run and the table will be deleted.

phpMyAdmin Drop Table
Fig.5 – phpMyAdmin Drop Table.
You can leave a response, or trackback from your own site.
Leave a Reply to the article


Learn PHP

Learning & Certifications
Follow Us
Facebook Icon   Linked In Icon   Twitter Icon  
Validation and Recognition

Valid CSS! Valid HTML5!          Protected by Copyscape