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:
“To write it, it took three months; to conceive it three minutes; to collect the data in itall my life.”
—F. Scott Fitzgerald (18961940)
“When we say science we can either mean any manipulation of the inventive and organizing power of the human intellect: or we can mean such an extremely different thing as the religion of science the vulgarized derivative from this pure activity manipulated by a sort of priestcraft into a great religious and political weapon.”
—Wyndham Lewis (18821957)
Related Subjects
Related Phrases
Related Words