[Step 08] How do I delete existing data in the table mysql

In today's post we (BeCoding.tk) will teach you all how to delete data stored on mysql table. Now you try to reopen a database that has been created in the learning part six and seven, go back and show all existing data on the table "items".
if you do not have the database please first read the part six and seven learners.

ScreenShot: Select DB and show data table [Click Here] 
The data we have show, so now we need to know the structure of a data delete command mysql namely:
delete from table_name where criteria;
  
 *Notes:

table_name	:	is the target table data you want to delete.
criteria	:	a requirement that the identity of the data.

*Warning:
if you do the removal without entering criteria, then all existing data in the table will be deleted.

For example, we will delete the data item "NEXUS 7" then the command is
delete from items where items_id='A001';
and then try to check whether it has been completely erased.
ScreenShot: Delete data [Click Here] 

That's how to delete a table of data in mysql, this study may be useful for you all.
thanks admin say to visitors who come and read to the end.
if you have problems you can ask us through the comments or contact us via the contact page.