The actual procedure for MySQL to delete form data

This article mainly describes how to delete form data from MySQL and how to describe the actual application code. The following is a detailed description of this article, I hope it will help you in this regard.

MySQL deletes form data 1

Use the DELETE statement to DELETE the data records in the form. Xiaohong is no longer in use. You have to DELETE the records.

 
 

  
  
MySQL (best combination with PHP)> delete from emp where emp_name = 'small red ';
 
 

After successful execution, the following information is displayed:

 
 

  
  
Query OK, 1 row affected (0.06 sec) 
 
 

If the where clause is omitted, records in all tables are deleted.

MySQL deletes form data 2

Use DRO to delete a table

(Create a database dt and a temporary table fuck)

 
 

  
  
MySQL (best combination with PHP)> drop table fuck;
 
 

MySQL deletes form data 3

Delete a database using DRO

 
 

  
  
MySQL (the best combination with PHP)> drop database dt;
 
 

The above content is an introduction to MySQL table deletion. I hope you will get some benefits.