ndb_delete_all(1)

ndb_delete_all1

Delete all rows from ndb table

Usage

ndb_delete_all options

Overview

ndb_delete_all deletes all rows from the given NDB table. In some cases, this can be much faster than DELETE or even TRUNCATE.

Usage:

ndb_delete_all -c connect_string tbl_name -d db_name

This deletes all rows from the table named tbl_name in the database named db_name. It is exactly equivalent to executing TRUNCATE db_name.tbl_name in MySQL.

Additional Options:

•

--transactional, -t

Use of this option causes the delete operation to be performed as a single transaction.

Warning With very large tables, using this option may cause the number of operations available to the cluster to be exceeded.

Author

MySQL AB (http://www.mysql.com/).

From mysql-server-5.0 5.0.51a-24+lenny5 in Debian 5.0 (Lenny). Parsed by carta from the page's man source.