Data Manipulation Language (DML)

Data Manipulation Language (DML) is the subset of SQL used to add, modify, or delete the actual data stored within your database tables.

Unlike DDL (which alters the structure of the database), DML operations only affect the rows of data inside those structures. In Oxibase, all DML operations are fully ACID-compliant and respect Multi-Version Concurrency Control (MVCC), meaning your data remains consistent even when multiple users are reading and writing simultaneously.

Core Operations

• INSERT: Adds new rows of data into a table. Supports single-row, multi-row, and upsert (ON DUPLICATE KEY UPDATE) operations.
• UPDATE: Modifies existing rows of data in a table based on a condition.
• DELETE: Removes specific rows of data from a table based on a condition.

Bulk Operations

When dealing with large volumes of data, standard row-by-row DML operations can be slow. Oxibase provides optimized commands for these scenarios:

• COPY FROM: The fastest and recommended way to bulk-import massive amounts of data from CSV or JSON files into a table.
• TRUNCATE: Instantly removes all rows from a table. This is significantly faster than a DELETE statement without a WHERE clause because it reclaims the storage immediately without logging individual row deletions.

---

Table of contents

• COPY FROM
• DELETE
• INSERT
• TRUNCATE
• UPDATE