Tables

Manage tables in MariaDB Server. This section details creating, altering, and dropping tables, along with understanding data types and storage engines for optimal database design.

Copying Tables Between Databases and Servers

This guide explains various methods for copying tables between MariaDB databases and servers, including using FLUSH TABLES FOR EXPORT and mysqldump.

ALTER TABLE

Complete ALTER TABLE guide for MariaDB. Complete syntax for modifying columns, indexes, constraints, and table properties with comprehensive examples.

CREATE TABLE

Complete guide to creating tables in MariaDB. Complete CREATE TABLE syntax for data types, constraints, indexes, and storage engines for production use.

DROP TABLE

Complete DROP TABLE syntax: TEMPORARY, IF EXISTS, WAIT/NOWAIT, RESTRICT/CASCADE options, metadata locks, atomic DROP, and replication behavior.

Data Types

Comprehensive MariaDB data types reference. Complete guide for numeric, string, date/time, spatial, and JSON types with storage specifications.

Storage Engines

Understand MariaDB Server's storage engines. Explore the features and use cases of InnoDB, Aria, MyISAM, and other engines to choose the best option for your specific data needs.

The task-oriented table tutorials now live in the Quickstart Guides:

• Altering Tables

• Getting Started with Indexes

• Creating & Using Views

_{This page is licensed: CC BY-SA / Gnu FDL}