Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
SingleStore Managed Service does not support this command.
A convenience wrapper for executing arbitrary SQL queries on a node.
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:
sdb-admin query --sql 'select * from data' --memsql-id 0123ABCDEF
sdb-admin query --sql 'select * from data' --host memsql-01 --port 3306 --password mypassword
Usage:
sdb-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 SingleStore DB
--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 SingleStore DB 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 File path for the Toolbox configuration
--disable-colors Disable colored output in console, which some terminal sessions/environments may have issues with
--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
This command is interactive unless you use either the --yes
or --json
flags to override interactive behavior.