Editing Data manipulation language (section)

{{Short description|Programming language for manipulating data}}
{{Other uses|Manipulation (disambiguation){{!}}Manipulation}}
{{Multiple issues|
{{Refimprove|date=June 2009}}
{{Cleanup|reason=the article focuses almost entirely on SQL.|date=June 2020}}
}}
A '''data manipulation language''' ('''DML''') is a computer [[programming language]] used for adding (inserting), deleting, and modifying (updating) data in a [[database]]. A DML is often a [[sublanguage]] of a broader [[Database#Languages|database language]] such as [[SQL]], with the DML comprising some of the operators in the language.<ref>{{cite book
|title=Structured Query Language By Example - Volume I: Data Query Language
|first=Mark
|last=Chatham
|year=2012
|isbn=978-1-29119951-2
|page=[https://books.google.com/books?id=64MBBAAAQBAJ&pg=PA8 8]
|publisher=Lulu.com
}}</ref> Read-only selecting of data is sometimes distinguished as being part of a separate [[data query language]] (DQL), but it is closely related and sometimes also considered a component of a DML; some operators may perform both selecting (reading) and writing.

A popular data manipulation language is that of [[Structured Query Language]] (SQL), which is used to retrieve and manipulate [[data]] in a [[relational database]].<ref name="SQL92" >[[#SQL92|SQL92]]</ref> Other forms of DML are those used by [[Information Management System|IMS]]/DLI, [[CODASYL]] databases, such as [[IDMS]] and others.