doc-exports/docs/ddm/umn/ddm_08_0008.html
Ru, Li Yi 4b09a03a51 ddm_umn
Reviewed-by: Wagner, Fabian <fabian.wagner@t-systems.com>
Co-authored-by: Ru, Li Yi <liyiru7@huawei.com>
Co-committed-by: Ru, Li Yi <liyiru7@huawei.com>
2024-04-11 11:39:26 +00:00

1.1 KiB

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.
  • PARTITION clauses are not supported.