MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide

18.4.23 ndb_select_all — Print Rows from an NDB Table

ndb_select_all prints all rows from an NDB table to stdout.

Usage

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

The following table includes options that are specific to the NDB Cluster native backup restoration program ndb_select_all. Additional descriptions follow the table. For options common to most NDB Cluster programs (including ndb_select_all), see Section 18.4.29, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”.

Table 18.35 Command-line options for the ndb_select_all program

Format Description Added, Deprecated, or Removed

--database=dbname,

-d

Name of database in which table is found

(Supported in all MySQL 5.6 based releases)

--parallelism=#,

-p

Degree of parallelism

(Supported in all MySQL 5.6 based releases)

--lock=#,

-l

Lock type

(Supported in all MySQL 5.6 based releases)

--order=index,

-o

Sort resultset according to index having this name

(Supported in all MySQL 5.6 based releases)

--descending,

-z

Sort resultset in descending order (requires --order)

(Supported in all MySQL 5.6 based releases)

--header,

-h

Print header (set to 0|FALSE to disable headers in output)

(Supported in all MySQL 5.6 based releases)

--useHexFormat,

-x

Output numbers in hexadecimal format

(Supported in all MySQL 5.6 based releases)

--delimiter=char,

-D

Set column delimiter

(Supported in all MySQL 5.6 based releases)

--disk

Print disk references (useful only for Disk Data tables having nonindexed columns)

(Supported in all MySQL 5.6 based releases)

--rowid

Print row ID

(Supported in all MySQL 5.6 based releases)

--gci

Include GCI in output

(Supported in all MySQL 5.6 based releases)

--gci64

Include GCI and row epoch in output

(Supported in all MySQL 5.6 based releases)

--tupscan,

-t

Scan in tup order

(Supported in all MySQL 5.6 based releases)

--nodata

Do not print table column data

(Supported in all MySQL 5.6 based releases)


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

All string values are enclosed by square brackets ([...]) in the output of ndb_select_all. Now 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)
)
TABLESPACE ts STORAGE DISK
ENGINE=NDBCLUSTER;

INSERT INTO dogs VALUES
    ('', 'Lassie', 'collie'),
    ('', 'Scooby-Doo', 'Great Dane'),
    ('', 'Rin-Tin-Tin', 'Alsatian'),
    ('', 'Rosscoe', 'Mutt');

This demonstrates the use of several additional ndb_select_all options:

shell> ./ndb_select_all -d ctest1 dogs -o ix -z --gci --disk
GCI     id name          breed        DISK_REF
834461  2  [Scooby-Doo]  [Great Dane] [ m_file_no: 0 m_page: 98 m_page_idx: 0 ]
834878  4  [Rosscoe]     [Mutt]       [ m_file_no: 0 m_page: 98 m_page_idx: 16 ]
834463  3  [Rin-Tin-Tin] [Alsatian]   [ m_file_no: 0 m_page: 34 m_page_idx: 0 ]
835657  1  [Lassie]      [Collie]     [ m_file_no: 0 m_page: 66 m_page_idx: 0 ]
4 rows returned

NDBT_ProgramExit: 0 - OK