[WHERE clause] [ORDER BY clause] [LIMIT clause]"."/> [WHERE clause] [ORDER BY clause] [LIMIT clause]".">
Home >Database >Mysql Tutorial >What is the mysql statement to delete data?
The mysql statement to delete data is "DELETE", which can delete one or more rows of data in the data table. The syntax format is "DELETE FROM ccc43248daffbac9770dee47fdaff697 [WHERE clause] [ORDER BY clause] [LIMIT clause]".
The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.
In MySQL, you can use the DELETE statement to delete one or more rows of data in a table.
DELETE statement can delete data from a single table. The syntax format is:
DELETE FROM <表名> [WHERE 子句] [ORDER BY 子句] [LIMIT 子句]
The syntax description is as follows:
Note: When the WHERE condition is not used, all data will be deleted.
Usage example of DELETE statement
Delete all data in the table
[Example 1] Delete all data in the tb_courses_new tablemysql> DELETE FROM tb_courses_new; Query OK, 3 rows affected (0.12 sec) mysql> SELECT * FROM tb_courses_new; Empty set (0.00 sec)
Delete data in the table based on conditions
[Example 2] In the tb_courses_new table, delete the course_id as 4 The recordmysql> DELETE FROM tb_courses -> WHERE course_id=4; Query OK, 1 row affected (0.00 sec) mysql> SELECT * FROM tb_courses; +-----------+-------------+--------------+------------------+ | course_id | course_name | course_grade | course_info | +-----------+-------------+--------------+------------------+ | 1 | Network | 3 | Computer Network | | 2 | Database | 3 | MySQL | | 3 | Java | 4 | Java EE | +-----------+-------------+--------------+------------------+ 3 rows in set (0.00 sec)It can be seen from the running results that the record with course_id 4 has been deleted. [Related recommendations:
mysql video tutorial]
The above is the detailed content of What is the mysql statement to delete data?. For more information, please follow other related articles on the PHP Chinese website!