Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
BATCH statement splits large transactions into several small transactions. The entire process does not guarantee atomicity, but each batch maintains atomicity.BATCH statement supports the DELETE operation.BATCH LIMIT batch_size delete_stmt
Parameter | Required | Description |
LIMIT batch_size | Required | Control the granularity of transaction splitting and set the size for each batch of non-transactional batch deletion. |
delete_stmt | Required | DELETE statement. |
BATCH statement cannot be nested within multi-statement transactions.batch_size must be a positive integer and cannot be zero.WHERE clause does not support the use of ORDER BY and LIMIT clauses.batch_size of 2,000, a transaction commit is performed for every 2,000 records during deletion; meaning each small transaction contains 2,000 deletion operations.BATCH LIMIT 2000 DELETE FROM sbtest1 WHERE id > 1000
피드백