Data Manipulation
The Data Manipulation Language (DML) is the subset of SQL used to add, update and delete data:
INSERT
adds rows (formally tuples) to an existing table, e.g.:
UPDATE
modifies a set of existing table rows, e.g.:
DELETE
removes existing rows from a table, e.g.:
MERGE
is used to combine the data of multiple tables. It combines theINSERT
andUPDATE
elements. It is defined in the SQL:2003 standard; prior to that, some databases provided similar functionality via different syntax, sometimes called "upsert".
Read more about this topic: SQL
Famous quotes containing the words data and/or manipulation:
“Mental health data from the 1950s on middle-aged women showed them to be a particularly distressed group, vulnerable to depression and feelings of uselessness. This isnt surprising. If society tells you that your main role is to be attractive to men and you are getting crows feet, and to be a mother to children and yours are leaving home, no wonder you are distressed.”
—Grace Baruch (20th century)
“The basic tool for the manipulation of reality is the manipulation of words. If you can control the meaning of words, you can control the people who must use the words.”
—Philip K. Dick (19281982)
Related Subjects
Related Phrases
Related Words