A convenience wrapper for executing arbitrary SQL queries on a node.

Usage

A convenience wrapper for executing arbitrary SQL queries on a node

A cluster node is specified using the --memsql-id flag. This will use memsqlctl to execute the query.
A node may alternatively be specified using a combination of --host, --port, --user, and --password.
This is not recommended because it can result in connecting to a node outside the cluster.

Examples:

    memsql-admin query --sql 'select * from data' --memsql-id 0123ABCDEF

    memsql-admin query --sql 'select * from data' --host memsql-01 --port 3306 --password mypassword

Usage:
  memsql-admin query [flags]

Flags:
  -h, --help                   Help for query
      --host string            The cluster-addressable hostname for the node
      --max-column-width int   The maximum width of a column in a query result. The supplied value cannot be less than 60. To disable the limitation, set the value to 0 (default 60)
      --memsql-id MemsqlID     The MemSQL ID of the node to query
  -p, --password STRING        The user's password for connecting to MemSQL
      --port PORT              The cluster-addressable port for the node
      --row-timeout duration   Maximum time to wait for each row in the result (e.g., 30s, 10m, 1.5h); defaults to 1 minute (default 1m0s)
      --sql string             The SQL query to run
      --user string            The MemSQL database user

Global Flags:
      --backup-cache FILE_PATH              File path for the backup cache
      --cache-file FILE_PATH                File path for the Toolbox node cache
  -c, --config FILE_PATH                    Toolbox configuration file path
      --disable-spinner                     Disable the progress spinner, which some terminal sessions/environments may have issues with
  -j, --json                                Enable JSON output
      --parallelism POSITIVE_INTEGER        Maximum number of operations to run in parallel
      --runtime-dir DIRECTORY_PATH          Where to store Toolbox runtime data
      --ssh-max-sessions POSITIVE_INTEGER   Maximum number of SSH sessions to open per host, must be at least 3
      --state-file FILE_PATH                Toolbox state file path
  -v, --verbosity count                     Increase logging verbosity: valid values are 1, 2, 3. Usage -v=count or --verbosity=count
  -y, --yes                                 Enable non-interactive mode and assume the user would like to move forward with the proposed actions by default

Remarks

This command is interactive unless you use either the --yes or --json flags to override interactive behavior.

Was this Article Helpful?

Thanks For Your Feedback!