dadrobna/distributed-database-middleware
1
0
Fork 0
forked from docs/distributed-database-middleware
Code Pull Requests Activity
distributed-database-middle.../umn/source/sql_syntax/dml/delete.rst
proposalbot 78ac771d84 Changes to ddm_umn from docs/doc-exports#613 (DDM UMN 1st version 
DDM UMN 1st v

Reviewed-by: Wagner, Fabian <fabian.wagner@t-systems.com>
Co-authored-by: proposalbot <proposalbot@otc-service.com>
Co-committed-by: proposalbot <proposalbot@otc-service.com>
2024-01-08 13:37:20 +00:00

517 B
Raw Permalink Blame History

original_name

ddm-08-0008.html

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.