4
Table Statements
Articles about creating, modifying, and maintaining tables in MariaDB.
-
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. -
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 creates 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.
