Updated on 2022-09-16 GMT+08:00
DELETE
DELETE is used to delete rows that meet conditions from a table.
Common Syntax
DELETE [IGNORE] FROM tbl_name [WHERE where_condition]
Syntax Restrictions
- The WHERE clause does not support subqueries, including correlated and non-correlated subqueries.
- Data in reference tables cannot be deleted when multiple tables are deleted at a time.
Parent topic: DML
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
