SYNOPSIS
       ndb_select_all -c connect_string tbl_name -d db_name [> file_name]

DESCRIPTION
       ndb_select_all prints all rows from an NDB table to stdout.

       Usage:

          ndb_select_all -c connect_string tbl_name -d db_name [> file_name]

       Additional Options:

       o  --lock=lock_type, -l lock_type

          Employs a lock when reading the table. Possible values for lock_type
          are:

          o  0: Read lock

          o  1: Read lock with hold

          o  2: Exclusive read lock

          There is no default value for this option.

       o  --order=index_name, -o index_name

          Orders the output according to the index named index_name. Note that
          this is the name of an index, not of a column, and that the index
          must have been explicitly named when created.

       o  --descending, -z

          Sorts the output in descending order. This option can be used only
          in conjunction with the -o (--order) option.

       o  --header=FALSE

          Excludes column headers from the output.

       o  --useHexFormat -x

          Causes all numeric values to be displayed in hexadecimal format.
          This does not affect the output of numerals contained in strings or
          datetime values.

       o  --delimiter=character, -D character

          Causes the character to be used as a column delimiter. Only table
          data columns are separated by this delimiter.

          The default delimiter is the tab character.

       o  --tupscan, -t

          Scan the table in the order of the tuples.

       o  --nodata

          Causes any table data to be omitted.


       Sample Output:

       Output from a MySQL SELECT statement:

          mysql> SELECT * FROM ctest1.fish;
          +----+-----------+
          | id | name      |
          +----+-----------+
          |  3 | shark     |
          |  6 | puffer    |
          |  2 | tuna      |
          |  4 | manta ray |
          |  5 | grouper   |
          |  1 | guppy     |
          +----+-----------+
          6 rows in set (0.04 sec)

       Output from the equivalent invocation of ndb_select_all:

          shell> ./ndb_select_all -c localhost fish -d ctest1
          id      name
          3       [shark]
          6       [puffer]
          2       [tuna]
          4       [manta ray]
          5       [grouper]
          1       [guppy]
          6 rows returned
          NDBT_ProgramExit: 0 - OK

       Note that all string values are enclosed by square brackets ("[...]")
       in the output of ndb_select_all. For a further example, consider the
       table created and populated as shown here:

          CREATE TABLE dogs (
              id int(11) not null auto_increment,
              name varchar(25) not null,
              breed varchar(50) not null,
              PRIMARY KEY pk (id),
              KEY ix (name)
          )
          ENGINE=NDBCLUSTER;
          INSERT INTO dogs VALUES
              ('', 'Lassie', 'collie'),
              ('', 'Scooby-Doo', 'Great Dane'),

          NDBT_ProgramExit: 0 - OK

COPYRIGHT
       Copyright 2007-2008 MySQL AB, 2009 Sun Microsystems, Inc.

       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.

       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.

       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/.

SEE ALSO
       For more information, please refer to the MySQL Reference Manual, which
       may already be installed locally and which is also available online at
       http://dev.mysql.com/doc/.

AUTHOR
       Sun Microsystems, Inc. (http://www.mysql.com/).