| blob | c5e46812d3906ae64e6c9b965e5e656573f3b1c3 |
1 '\" t
2 .\" Title: \fBndb_select_count\fR
3 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4 .\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
5 .\" Date: 11/04/2013
6 .\" Manual: MySQL Database System
7 .\" Source: MySQL 5.1
8 .\" Language: English
9 .\"
10 .TH "\FBNDB_SELECT_COUNT\" "1" "11/04/2013" "MySQL 5\&.1" "MySQL Database System"
11 .\" -----------------------------------------------------------------
12 .\" * Define some portability stuff
13 .\" -----------------------------------------------------------------
14 .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
15 .\" http://bugs.debian.org/507673
16 .\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
17 .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
18 .ie \n(.g .ds Aq \(aq
19 .el .ds Aq '
20 .\" -----------------------------------------------------------------
21 .\" * set default formatting
22 .\" -----------------------------------------------------------------
23 .\" disable hyphenation
24 .nh
25 .\" disable justification (adjust text to left margin only)
26 .ad l
27 .\" -----------------------------------------------------------------
28 .\" * MAIN CONTENT STARTS HERE *
29 .\" -----------------------------------------------------------------
30 .\" ndb_select_count
31 .SH "NAME"
32 ndb_select_count \- print row counts for NDB tables
33 .SH "SYNOPSIS"
34 .HP \w'\fBndb_select_count\ [\-c\ \fR\fB\fIconnect_string\fR\fR\fB]\ \-d\ \fR\fB\fIdb_name\fR\fR\fB\ \fR\fB\fItbl_name\fR\fR\fB[\ \fR\fB\fItbl_name2\fR\fR\fB[\ \&.\&.\&.]]\fR\ 'u
35 \fBndb_select_count [\-c \fR\fB\fIconnect_string\fR\fR\fB] \-d \fR\fB\fIdb_name\fR\fR\fB \fR\fB\fItbl_name\fR\fR\fB[ \fR\fB\fItbl_name2\fR\fR\fB[ \&.\&.\&.]]\fR
36 .SH "DESCRIPTION"
37 .PP
38 \fBndb_select_count\fR
39 prints the number of rows in one or more
40 NDB
41 tables\&. With a single table, the result is equivalent to that obtained by using the MySQL statement
42 SELECT COUNT(*) FROM \fItbl_name\fR\&.
43 Usage
44 .sp
45 .if n \{\
46 .RS 4
47 .\}
48 .nf
49 ndb_select_count [\-c \fIconnect_string\fR] \-d\fIdb_name\fR \fItbl_name\fR[, \fItbl_name2\fR[, \&.\&.\&.]]
50 .fi
51 .if n \{\
52 .RE
53 .\}
54 .PP
55 The following table includes options that are specific to the MySQL Cluster native backup restoration program
56 \fBndb_select_count\fR\&. Additional descriptions follow the table\&. For options common to most MySQL Cluster programs (including
57 \fBndb_select_count\fR), see
58 Options Common to MySQL Cluster Programs(1)\&.
59 .sp
60 .it 1 an-trap
61 .nr an-no-space-flag 1
62 .nr an-break-flag 1
63 .br
64 .B Table\ \&17.25.\ \&ndb_select_count Options and Variables: MySQL 5.1, MySQL Cluster NDB 6.3-7.1
65 .TS
66 allbox tab(:);
67 lB lB lB.
68 T{
69 Format
70 T}:T{
71 Description
72 T}:T{
73 Added / Removed
74 T}
75 .T&
76 l l l
77 l l l
78 l l l.
79 T{
80 .PP
81 \-\-database=dbname,
82 .PP
83 \-d
84 T}:T{
85 Name of the database in which the table is found
86 T}:T{
87 .PP
88 All MySQL 5\&.1 based releases
89 T}
90 T{
91 .PP
92 \-\-parallelism=#,
93 .PP
94 \-p
95 T}:T{
96 Degree of parallelism
97 T}:T{
98 .PP
99 All MySQL 5\&.1 based releases
100 T}
101 T{
102 .PP
103 \-\-lock=#,
104 .PP
105 \-l
106 T}:T{
107 Lock type
108 T}:T{
109 .PP
110 All MySQL 5\&.1 based releases
111 T}
112 .TE
113 .sp 1
114 .PP
115 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
116 \fBSample Output\fR\&.
117 Sample Output
118 .sp
119 .if n \{\
120 .RS 4
121 .\}
122 .nf
123 shell> \fB\&./ndb_select_count \-c localhost \-d ctest1 fish dogs\fR
124 6 records in table fish
125 4 records in table dogs
126 NDBT_ProgramExit: 0 \- OK
127 .fi
128 .if n \{\
129 .RE
130 .\}
131 .SH "COPYRIGHT"
132 .br
133 .PP
134 Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
135 .PP
136 This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
137 .PP
138 This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
139 .PP
140 You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
141 .sp
142 .SH "SEE ALSO"
143 For more information, please refer to the MySQL Reference Manual,
144 which may already be installed locally and which is also available
145 online at http://dev.mysql.com/doc/.
146 .SH AUTHOR
147 Oracle Corporation (http://dev.mysql.com/).