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
Apakah halaman ini membantu?
Anda juga dapat Menghubungi Penjualan atau Mengirimkan Tiket untuk meminta bantuan.
masukan