SQL Statements for MariaDB Xpand 23.09
This page is part of MariaDB's Documentation.
The parent of this page is: Reference for MariaDB Xpand 23.09
Topics on this page:
Overview
Structured Query Language (SQL) statements enable the reading and writing of data within the database. MariaDB Xpand implements classic and modern SQL database features.
SQL Statement | Description |
---|---|
Contains several sub-statements that can be used to alter an Xpand cluster | |
Adds node(s) to an Xpand cluster with the | |
Drops a failed node from the cluster and triggers a group change | |
Reforms the cluster and triggers a group change to apply changes made by previous ALTER CLUSTER statements | |
Reloads the RSA key pair used by the | |
Reloads the TLS/SSL certificates and keys that are defined by | |
Resizes the | |
Modifies an Xpand cluster, configures the Rebalancer to sets the number of replicas and acceptors to maintain, specifying the maximum number of Xpand nodes that can fail simultaneously without data loss | |
Starts a softfail process for one or more nodes, which configures the Rebalancer to move data off of the nodes so that they can be safely removed from the cluster | |
Cancels a softfail process for one or more nodes | |
Adds one or more nodes into a zone | |
Modifies database characteristics, such as changing the default character-set and collation | |
Modifies stored function characteristics, including whether it contains SQL, modifies data, and its privilege requirements. Does not support modifying the stored function code. | |
Modifies stored procedure characteristics, including whether it contains SQL code, modifies data, and its privilege requirements. Does not support modifying the stored procedure code. | |
See | |
Modifies sequence characteristics, including its increment, minimum, maximum, and starting values | |
Modifies table characteristics, including changing the name, reordering the columns, and changing column data types | |
Modifies user characteristics, including changing and setting account authentication, TLS restrictions, and password expiration | |
Modifies view characteristics, including the view algorithm, name, and definer | |
Evaluates and stores index statistics for a table. The table remains locked during analysis. | |
Creates a backup | |
Executes a stored procedure or function | |
Specifies the primary server to use in replication | |
Ends a transaction, saving all associated changes so that they become visible to subsequent transactions | |
Creates a database | |
Creates a stored function and specifies the code it executes | |
Creates and builds indexes for the table | |
Creates a stored procedure and specifies the code it executes | |
Creates a role | |
Creates and specifies a table for data storage | |
Creates a trigger event and specifies the conditions in which it runs | |
Creates a user account | |
Creates view of the database as specified from the given | |
Deallocates a prepared statement. The | |
Removes rows of data from the given table or tables | |
See | |
Provides the table specification | |
Deletes the given database with all its tables and data | |
Deletes a user-defined or stored function | |
Deletes an index from the table | |
Deletes a prepared statement | |
Deletes a stored procedure | |
Deletes a role | |
Deletes a table and the data it contains from the database | |
Deletes a trigger from tables and database | |
Deletes a user account | |
Deletes a view of the database | |
Runs a prepared statement | |
Provides information on table specifications or on how MariaDB Xpand executes the given SQL statement. See | |
Clears or reloads various internal caches | |
Assigns privileges to a user account or security role | |
Adds a row or rows of data to table | |
Terminates a statement or thread | |
Copies rows from a text file into the designated table | |
Performs optimization on tablespaces, defragmenting files and updating InnoDB Full Text indexes | |
Creates a prepared statement and assigns it a name for later use | |
Removes the specified savepoint from a transaction. It does not rollback or commit any changes. | |
Renames one or more tables or views, but not the associated privileges | |
Repairs corrupted tables and improves compression | |
Adds a new row or rows to the table, replacing the row in the event of a conflict with Primary or Unique index keys | |
Restores a backup | |
Removes privileges granted to a user account or security role | |
Cancels a transaction and reverts any changes made to data, so that they never become visible to subsequent transactions | |
Creates a named sub-transaction | |
Retrieves data from one or more tables | |
Assigns a value to various types of variables, which can affect server and client operations | |
Defines the character-set and collation to use for strings sent between the current client and server | |
Sets the default role for the specified user | |
Defines the character-set and collation the client uses to send to the server and the server uses to send to the client | |
Defines the password for the given user account | |
Activates the role for the current user's session | |
Provides information about databases, tables, columns, or status information about the server | |
Lists the binary log files | |
Lists the available character-sets | |
Lists the available character-set collations | |
Lists the column specifications for the given table or view | |
Provides the | |
Provides the | |
Provides the | |
Provides the | |
Provides the | |
Provides the | |
Provides the | |
Lists the available databases | |
Provides information on the available storage engines | |
Lists characteristics of the given stored function, like the database, name, type, and creator | |
Lists the privileges granted to the given user account | |
Provides information on indexes for the given table | |
See | |
See | |
See | |
Provides status information on the binary log files of the Primary Server. Alias for SHOW BINLOG STATUS in 10.5. | |
Lists non-temporary tables currently open in the table cache with additional information, including the database and table names, number of table instances in use, and whether the table is name-locked | |
Displays information about installed plugins | |
Lists characteristics of the given stored procedure, like the database, name, and creator | |
Lists information on the currently running threads, including their thread ID, user, command, time, and progress | |
See | |
Run on the Primary Server, lists information on the currently registers Replica Servers | |
Run on the Replica Server, lists status information on essential parameters of the replication threads | |
Lists status information | |
Lists information on the non-temporary tables, sequences, and views in the given database | |
Lists the non-temporary tables, sequences, and views in the given database | |
Lists information on the currently defined triggers for tables in the given database | |
Lists system variables and their current values | |
Lists the errors, warnings, and notes that resulted from the last statement | |
Shuts down the server | |
Empties the diagnostics area, producing a custom error. Useful in stored procedures and functions. | |
Initiates replication for the current Replica Server | |
Initiates a transaction | |
Halts replication for the current Replica Server | |
Removes all rows from the specified table | |
Sets new values on rows in a table or tables | |
Sets the default database |