- Documentation Library
- Table of Contents
- MySQL 5.5 Manual
- MySQL 5.4 Manual
- MySQL 5.1 Manual
- MySQL 5.0 Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
MySQL 3.23, 4.0, 4.1 Reference Manual :: 15 MySQL Cluster :: 15.4 MySQL Cluster Programs :: 15.4.17 ndb_select_count — Print Row Counts for NDB Tables
Section Navigation [Toggle]
- 15.4 MySQL Cluster Programs
- 15.4.1 MySQL Server Usage for MySQL Cluster
- 15.4.2 ndbd — The MySQL Cluster Data Node Daemon
- 15.4.3 ndb_mgmd — The MySQL Cluster Management Server Daemon
- 15.4.4 ndb_mgm — The MySQL Cluster Management Client
- 15.4.5 ndb_config — Extract MySQL Cluster Configuration Information
- 15.4.6 ndb_cpcd — Automate Testing for NDB Development
- 15.4.7 ndb_delete_all — Delete All Rows from an NDB Table
- 15.4.8 ndb_desc — Describe NDB Tables
- 15.4.9 ndb_drop_index — Drop Index from an NDB Table
- 15.4.10 ndb_drop_table — Drop an NDB Table
- 15.4.11 ndb_error_reporter — NDB Error-Reporting Utility
- 15.4.12 ndb_print_backup_file — Print NDB Backup File Contents
- 15.4.13 ndb_print_schema_file — Print NDB Schema File Contents
- 15.4.14 ndb_print_sys_file — Print NDB System File Contents
- 15.4.15 ndb_restore — Restore a MySQL Cluster Backup
- 15.4.16 ndb_select_all — Print Rows from an NDB Table
- 15.4.17 ndb_select_count — Print Row Counts for NDB Tables
- 15.4.18 ndb_show_tables — Display List of NDB Tables
- 15.4.19 ndb_size.pl — NDBCLUSTER Size Requirement Estimator
- 15.4.20 ndb_waiter — Wait for MySQL Cluster to Reach a Given Status
- 15.4.21 Options Common to MySQL Cluster Programs
ndb_select_count prints the number of rows
in one or more NDB tables. With a
single table, the result is equivalent to that obtained by
using the MySQL statement SELECT COUNT(*) FROM
.
tbl_name
Usage:
ndb_select_count [-cconnect_string] -ddb_nametbl_name[,tbl_name2[, ...]]
Additional Options: None that are specific to this application. However, you can obtain row counts from multiple tables in the same database by listing the table names separated by spaces when invoking this command, as shown under Sample Output.
Sample Output:
shell> ./ndb_select_count -c localhost -d ctest1 fish dogs
6 records in table fish
4 records in table dogs
NDBT_ProgramExit: 0 - OK
User Comments
Add your own comment.