SQL Commands List
Here is an alphabetical list of all the SQL commands SingleStoreDB Cloud currently supports. This list is subject to change.
Command Name | Command Description | Grouping |
---|---|---|
Sets the auto-increment counter on the aggregators (master or child). | Data Manipulation Language | |
Specify if an existing database should begin using synchronous or asynchronous replication. | Data Definition Language | |
The | Pipeline | |
Changes the resource settings in an existing resource pool. | Resource Pool | |
Modify the structure of an existing table. | Data Definition Language | |
Alters settings associated with the user. To change a user password, use the SET PASSWORD command. | Security Management | |
Atomically replace a view with a new view defined by a | Data Definition Language | |
Statistics for a table can be collected and updated on an ad hoc basis by running the | Operational | |
SingleStoreDB Cloud (MemSQL) Procedural SQL (MPSQL) supports the | Procedural | |
Restores an unlimited storage database at a restore point and then brings the database online. | Operational | |
Backs up a database. The backup files are saved on the master aggregator and on the leaves. | Operational | |
Commits any existing open transaction on the current connection and starts a new transaction. | Data Manipulation Language | |
Executes the specified stored procedure. Does not return results. | Procedural | |
| Operational | |
| Operational | |
Removes load errors from the | Data Manipulation Language | |
After | Procedural | |
Commits the open transaction if one exists. | Data Manipulation Language | |
Creates or replaces an external function, which is a function that calls code that is executed outside of a SingleStore database. | Procedural | |
When the session terminates, the temporary stored procedure is no longer available. | Procedural | |
Creates a user-defined aggregate function (UDAF). A UDAF is a callable routine that accepts input parameters, executes programmatic logic in the function body, and returns a scalar-type value. | Procedural | |
Creates a database. | Data Definition Language | |
Creates a user-defined table-valued function (TVF). A TVF is a callable routine that accepts input parameters, executes a single | Procedural | |
Creates a user-defined scalar-valued function (UDF). A UDF is a callable routine that accepts input parameters, executes programmatic logic, and returns a value (or values). | Procedural | |
Create a group on a SingleStoreDB Cloud workspace. | Security Management | |
Create an index on the specified table. | Data Definition Language | |
Create a new connection link to S3, Azure, GCS, HDFS, HTTP, or Kafka for a permitted user. | Security Management | |
Records a milestone, which is a named point to which you can restore an unlimited storage database. Restoring to the milestone will bring the database to the point in time when the milestone was created. | Data Definition Language | |
Create a new Pipeline to continuously extract, shape, and load data into a table or stored procedure. | Pipeline | |
Creates a stored procedure. A stored procedure is a callable routine that accepts input parameters, executes programmatic logic, and optionally returns a single value. | Procedural | |
Creates a resource pool. | Resource Pool | |
Create a role on a SingleStoreDB Cloud workspace. | Security Management | |
Creates a new table. | Data Definition Language | |
Create a new user account. | Security Management | |
Create an unmaterialized view. | Data Definition Language | |
Creates a new array of the specified length that is initialized with default values for the array’s inferred data type. | Procedural | |
Returns a comma separated list of the current user's security groups on a SingleStore workspace. | Security Management | |
Returns a comma separated list in one row of the current user's security roles on a SingleStore workspace. | Security Management | |
Returns the details (username and hostname) of the user executing the query. | Security Management | |
| Data Manipulation Language | |
Describe the specified table. | Data Definition Language | |
Takes an unlimited storage database offline. The data remains on remote storage and should be deleted separately if you wish to completely remove it. | Operational | |
The | Pipeline | |
Forces a plan to be optimized and generated from scratch the next time it is run. | Data Definition Language | |
Removes a single user-defined aggregate function (UDAF) from the specified database. | Procedural | |
Drops a local storage database. | Data Definition Language | |
Removes a single function from the specified database, including user-defined scalar-valued functions (UDFs) and user-defined table-valued functions (TVFs). | Procedural | |
Remove a group from a SingleStoreDB Cloud workspace. | Security Management | |
Drop the specified index on the specified table. | Data Definition Language | |
Remove a connection link on S3, Azure, GCS, HDFS, or Kafka for a permitted user. | Security Management | |
The | Pipeline | |
Removes a single stored procedure from the specified database. | Procedural | |
Drop the specified resource pool. | Resource Pool | |
Remove a role from a SingleStoreDB Cloud workspace. | Security Management | |
Drop the specified table. | Data Definition Language | |
Removes one or more user accounts. | Security Management | |
Drop a view. | Data Definition Language | |
Executes a stored procedure and returns a set of rows as a result. | Procedural | |
Within a stored procedure, executes the specified | Procedural | |
| Data Manipulation Language | |
Runs a SQL query. | Procedural | |
Used with a subquery to check if the subquery returns a record. | Data Manipulation Language | |
Returns detailed information on how the query is executed. | Data Manipulation Language | |
Grants the specified privileges to an existing user. The user will be created if it does not exist. | Security Management | |
Add a user to a group. | Security Management | |
Add a role to a group. | Security Management | |
Inserts data into a table. | Data Manipulation Language | |
Inserts an array of records into a table in a single operation. | Procedural | |
| Data Manipulation Language | |
Kill the connection on the specified thread. Rolls back any query running on the thread. | Operational | |
Kills all running queries or closes all connections. | Operational | |
Import data stored in a CSV, JSON, or Avro file into a SingleStoreDB table (referred to as the destination table in this topic). | Data Manipulation Language | |
| Data Definition Language | |
The | Data Manipulation Language | |
Provides detailed resources usage metrics about a query. | Data Manipulation Language | |
Runs a single batch in the foreground to provide detailed resource metrics for each operation in your pipeline. The batch itself is not persisted. | Pipeline | |
SingleStoreDB Cloud (MemSQL) Procedural SQL (MPSQL) supports the | Procedural | |
SingleStoreDB Cloud (MemSQL) Procedural SQL (MPSQL) supports the | Procedural | |
This command is deprecated. | Operational | |
If the table has a | Data Manipulation Language | |
Restores a database from a binary backup file. | Operational | |
Revoke privileges from a SingleStoreDB Cloud user or role. | Security Management | |
Remove a user from a group. | Security Management | |
Remove a role from a group. | Security Management | |
Rolls back the open transaction if one exists. | Data Manipulation Language | |
The | Procedural | |
The | Procedural | |
| Security Management | |
Retrieves data from a table. | Data Manipulation Language | |
Inspect the setting of a global engine variable. | Operational | |
Sets session variables. The variable’s value is effective for the user’s current connection to the node, until the node is restarted. | Operational | |
Sets a sync variable to propagate to all aggregators in the workspace. | Operational | |
Sets a sync variable. Depending on the variable, the updated value is propagated to all nodes in the workspace or all aggregators in the workspace. | Operational | |
Sets an engine variable globally. | Operational | |
Sets a sync variable to propagate to all leaves in the workspace. | Operational | |
Sets a user’s password. | Security Management | |
Lists any existing user-defined aggregate functions (UDAF) in the specified database. | Procedural | |
Show the list of columns within a given table. | Show Commands | |
Shows the function definition and other attributes for a user-defined aggregate function (UDAF). | Procedural | |
Outputs configuration information about an existing user-defined function or procedure, including user-defined scalar value functions (UDFs), user-defined table-valued functions (TVFs), and stored procedures (SPs). | Procedural | |
You can use the | Show Commands | |
Shows the | Show Commands | |
Shows the | Show Commands | |
Shows SingleStoreDB Cloud database status. | Show Commands | |
Shows the list of databases that exist on this SingleStoreDB Cloud instance. | Show Commands | |
Displays errors as a result of execution of an invalid statement. | Show Commands | |
Lists any existing user-defined functions in the specified database, including user-defined scalar-valued functions (UDFs) and user-defined table-valued functions (TVFs). | Procedural | |
Show global SingleStoreDB Cloud server status information. | Show Commands | |
Show permissions (privileges) for the specified user (or role). | Security Management | |
Shows the list of groups on a SingleStoreDB Cloud workspace | Security Management | |
Show groups for a specific role. | Security Management | |
Show groups for a specific user. | Security Management | |
Displays the list of indexes associated with a given table. | Show Commands | |
Show all connection links on S3, Azure, GCS, HDFS, or Kafka for a permitted user. | Security Management | |
This command is deprecated. You can now query the information_schema.LOAD_DATA_ERRORS table to see the errors that occurred after running the | Show Commands | |
This command is deprecated. You can now query the information_schema.LOAD_DATA_ERRORS table to see the warnings that occurred after running the | Show Commands | |
Shows partitions and relevant information about them. | Show Commands | |
You can see all existing pipelines in a database and their current state by using the | Show Commands | |
Displays the EXPLAIN plan of a query as per the plan ID. | Show Commands | |
Shows all query statements that SingleStoreDB Cloud has compiled and executed, as well as cumulative query execution statistics associated with each plan. | Show Commands | |
Shows details about currently running threads. | Show Commands | |
Shows the list of all connections between the replication master and secondary databases. | Operational | |
Collects troubleshooting data for query optimizer and code generation issues for queries that fail in the compilation phase. | Show Commands | |
Lists all resource pools and their field values. | Resource Pool | |
Shows the list of roles on a SingleStoreDB Cloud workspace | Security Management | |
Show roles for a specific group. | Security Management | |
Show roles for a specific user. | Security Management | |
Shows the list of schemas that exist on this SingleStoreDB Cloud instance. | Show Commands | |
Show SingleStoreDB Cloud server status information for a session. | Show Commands | |
Shows SingleStoreDB Cloud server status information with detailed SingleStoreDB Cloud-specific memory and performance statistics. | Show Commands | |
Show tables status information in a SingleStoreDB Cloud database. | Show Commands | |
Shows the list of tables in the currently selected database, or in another database if db_name is specified. | Show Commands | |
Show users on a SingleStoreDB Cloud workspace. | Security Management | |
Show users for a specific group. | Security Management | |
Show users for a specific role. | Security Management | |
Shows a list of variable bindings. | Show Commands | |
Display warnings as a result of an invalid statement execution. | Show Commands | |
Takes a snapshot of the given database and truncates the transaction log. | Operational | |
The | Pipeline | |
The | Pipeline | |
Synchronizes any currently committed data in the database with the remote object storage. | Operational | |
It is a table-valued function that converts a MPSQL array to a set of rows. | Data Manipulation Language | |
The | Pipeline | |
Allows you to convert a dynamic SQL statement to a query type value. | Procedural | |
Removes all rows from the table. | Data Definition Language | |
Combines results from multiple SELECT statements. | Data Manipulation Language | |
Releases all table locks on all databases in the workspace. | Data Definition Language | |
| Data Manipulation Language | |
Use a database or schema. | Data Manipulation Language | |
Specifies a temporary named result set, referred to as a Common Table Expression (CTE). | Data Manipulation Language |