DML
Technology & Computing abbreviation · Data & Database
| Stands for | Data manipulation language |
|---|---|
| Categories | Technology & Computing |
DML stands for Data manipulation language, a data & database abbreviation.
The subset of SQL that reads and changes the data inside tables, using SELECT, INSERT, UPDATE, DELETE and MERGE. Most day-to-day application queries are DML.
Example: The audit trigger logs every DML statement that touches the salaries table.
Usage notes
Some authors exclude SELECT and place it in a separate data query language. DML runs inside transactions, so changes can be committed or rolled back. Bulk updates on large tables can lock rows and bloat logs, so they are often split into batches.
Related abbreviations
More data & database abbreviations
- DAX – Data Analysis Expressions
- DB – Database
- DBA – Database administrator
- DBMS – Database management system
- dbt – data build tool
- DDL – Data definition language
- DS – Data science
- DWH – Data warehouse
- EDA – Exploratory data analysis
- EDW – Enterprise data warehouse
- ELK – Elasticsearch, Logstash, Kibana
- ELT – Extract, load, transform