> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-manipulation-statements.md).

# ColumnStore Data Manipulation Statements

- [ColumnStore DELETE](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-manipulation-statements/columnstore-delete.md): DELETE for MariaDB ColumnStore removes rows but does not reclaim disk space; use TRUNCATE, DROP PARTITION, or a CREATE/RENAME-based rebuild to recover space after deletes.
- [ColumnStore Disk-Based Joins](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-manipulation-statements/columnstore-disk-based-joins.md): Disk-based joins let MariaDB ColumnStore spill join intermediates to disk when in-memory join space is exhausted, controlled via AllowDiskBasedJoin in ColumnStore.xml; not for aggregation.
- [ColumnStore INSERT](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-manipulation-statements/columnstore-insert.md): INSERT for MariaDB ColumnStore adds rows to a table; use cpimport or batch INSERT INTO .. SELECT for high-volume bulk loads on the columnar engine.
- [ColumnStore LOAD DATA INFILE](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-manipulation-statements/columnstore-load-data-infile.md): LOAD DATA INFILE for MariaDB ColumnStore loads rows from a text file into a table at high speed; auto-translated to a cpimport bulk load when batch insert mode is on.
- [ColumnStore SELECT](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-manipulation-statements/columnstore-select.md): SELECT for MariaDB ColumnStore queries tables with the standard MariaDB syntax, supporting WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, and INTO OUTFILE / DUMPFILE export.
- [ColumnStore UPDATE](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-manipulation-statements/columnstore-update.md): UPDATE for MariaDB ColumnStore changes data in existing rows with single-table or multi-table syntax, supporting WHERE, ORDER BY, and LIMIT clauses.