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 (mysql_install_db)	Using mysql_install_db to create the system tables in the 'mysql' database directory
mysqlcheck	Tool for checking, repairing, analyzing and optimizing tables.
mysql_upgrade	Update to the latest version.
OPTIMIZE TABLE	Reclaim unused space and defragment data.
RENAME TABLE	Change a table's name.
REPAIR TABLE	Rapairs a table, if the storage engine supports this statement.
REPAIR VIEW	Fix view if the algorithms are swapped.
REPLACE	Equivalent to DELETE + INSERT, based on UNIQUE indexes.
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.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/table-statements/