Articles about creating, modifying, and maintaining tables in MariaDB.
-
ALTER
This category is for documentation on the various ALTER statements. -
Installing system tables (mysql_install_db)
mysql_install_db is needed to create the system tables in the 'mysql' datab... -
mysqlcheck
mysqlcheck is a maintenance tool that allows you to check, repair, analyze ... -
mysql_upgrade
mysql_upgrade is a tool that checks and updates your tables to the latest version. Usage: m -
ANALYZE TABLE
Syntax ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name [, tbl_name]... -
CHECK TABLE
Syntax CHECK TABLE tbl_name [, tbl_name] ... [option] ... option = {FOR UP... -
CHECKSUM TABLE
Syntax CHECKSUM TABLE tbl_name [, tbl_name] ... [ QUICK | EXTENDED ]Descrip... -
CREATE TABLE
Syntax: CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name (create_definition,...) [tab -
OPTIMIZE TABLE
Syntax OPTIMIZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name [, tbl_name... -
REPAIR TABLE
Syntax REPAIR [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name [, tbl_name] ... -
RESTORE TABLE
Syntax: RESTORE TABLE tbl_name [, tbl_name] ... FROM '/path/to/backup/direc... -
Upgrading to MariaDB from MySQL 5.0 (or older version)
If you upgrade to MariaDB 5.1 from MySQL 5.1 you don't have to do anything ... -
BACKUP table (deprecated)
The backup table command is deprecated (not reliable). For doing a backup o... -
DELETE
Syntax Single-table syntax: DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl... -
DROP TABLE
Syntax: DROP [TEMPORARY] TABLE [IF EXISTS] tbl_name [, tbl_name] ... ... -
RENAME TABLE
Syntax RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_na... -
TRUNCATE TABLE
Syntax TRUNCATE [TABLE] tbl_nameDescription TRUNCATE TABLE empties a table ... -
UPDATE
Syntax Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET col_name
