Table Statements
Articles about creating, modifying, and maintaining tables in MariaDB.
| Title | Description |
|---|---|
| ALTER | The various ALTER statements in MariaDB. |
| ANALYZE TABLE | Store key distributions for a table. |
| CHECK TABLE | Check table for errors. |
| CHECK VIEW | Check whether the view algorithm is correct. |
| CHECKSUM TABLE | Report a table checksum. |
| CREATE TABLE | Creates a new table. |
| DELETE | Delete rows from one or more tables. |
| DROP TABLE | Removes definition and data from one or more tables. |
| Installing System Tables (mariadb-install-db) | Using mariadb-install-db to create the system tables in the 'mysql' database directory. |
| mysqlcheck | Symlink or old name for mariadb-check. |
| mysql_upgrade | Symlink or old name for mariadb-upgrade. |
| OPTIMIZE TABLE | Reclaim unused space and defragment data. |
| RENAME TABLE | Change a table's name. |
| REPAIR TABLE | Repairs a table, if the storage engine supports this statement. |
| REPAIR VIEW | Fix view if the algorithms are swapped. |
| REPLACE | Equivalent to DELETE + INSERT, or just an INSERT if no rows are returned. |
| SHOW COLUMNS | Column information. |
| SHOW CREATE TABLE | Shows the CREATE TABLE statement that created the table. |
| SHOW INDEX | Information about table indexes. |
| TRUNCATE TABLE | DROP and re-CREATE a table. |
| UPDATE | Modify rows in one or more tables. |
| Obsolete Table Commands | Table commands that have been removed from MariaDB |
| IGNORE | Suppress errors while trying to violate a UNIQUE constraint. |
| System-Versioned Tables | System-versioned tables record the history of all changes to table data. |
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
© 2023 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/table-statements/