DML

Technology & Computing abbreviation · Data & Database

DML
Stands forData manipulation language
CategoriesTechnology & 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.

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

See all 53 data & database abbreviations →