Data manipulation language

DMLData Manipulation Language (DML)manipulation DMLdata manipulationmanipulating dataquery languages
A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database.wikipedia
53 Related Articles

SQL

Structured Query LanguageSQL DatabasesWikibook SQL
A DML is often a sublanguage of a broader database language such as SQL, with the DML comprising some of the operators in the language. A popular data manipulation language is that of Structured Query Language (SQL), which is used to retrieve and manipulate data in a relational database.
Originally based upon relational algebra and tuple relational calculus, SQL consists of many types of statements, which may be informally classed as sublanguages, commonly: a data query language (DQL), a data definition language (DDL), a data control language (DCL), and a data manipulation language (DML).

Database

database management systemdatabasesdatabase systems
A DML is often a sublanguage of a broader database language such as SQL, with the DML comprising some of the operators in the language. A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database.
Data manipulation language (DML) – performs tasks such as inserting, updating, or deleting data occurrences;

Sublanguage

A DML is often a sublanguage of a broader database language such as SQL, with the DML comprising some of the operators in the language.
SQL (Structured Query Language) statements are classified in various ways, which can be grouped into sublanguages, commonly: a data query language (DQL), a data definition language (DDL), a data control language (DCL), and a data manipulation language (DML).

Query language

querydatabase languagedatabase query language
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.
SQL is a well known query language and data manipulation language for relational databases;

CODASYL

Conference on Data System LanguagesCodasyl database specifications
Other forms of DML are those used by IMS/DLI, CODASYL databases, such as IDMS and others.
This specification in fact defined several separate languages: a data definition language (DDL) to define the schema of the database, another DDL to create one or more subschemas defining application views of the database; and a data manipulation language (DML) defining verbs for embedding in the COBOL programming language to request and update data in the database.

Oracle Database

OracleOracle 10gOracle 8i
Examples of these are Oracle's PL/SQL and DB2's SQL_PL.
iSQL*Plus, a web-browser-based graphical user interface (GUI) for manipulating data in an Oracle database (compare SQL*Plus)

Data definition language

DDLdata definition DDL
Manipulation of persistent database objects, e.g., tables or stored procedures, via the SQL schema statements, rather than the data stored within them, is considered to be part of a separate data definition language (DDL).
Some forms of CREATE TABLE DDL may incorporate DML (data manipulation language)-like constructs, such as the CREATE TABLE AS SELECT (CTAS) syntax of SQL.

PL/SQL

Metatranz StepSqlitePL/SQL (Oracle)
Examples of these are Oracle's PL/SQL and DB2's SQL_PL.
While programmers can readily embed Data Manipulation Language (DML) statements directly into PL/SQL code using straightforward SQL statements, Data Definition Language (DDL) requires more complex "Dynamic SQL" statements in the PL/SQL code.

Data control language

DCLGRANT
Data control language
The operations for which privileges may be granted to or revoked from a user or role apply to both the Data definition language (DDL) and the Data manipulation language (DML), and may include CONNECT, SELECT, INSERT, UPDATE, DELETE, EXECUTE, and USAGE.

Programming language

programming languageslanguagedialect
A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database.

Data

statistical datascientific datadatum
A popular data manipulation language is that of Structured Query Language (SQL), which is used to retrieve and manipulate data in a relational database.

Relational database

relational databasesrelationaldatabase constraints
A popular data manipulation language is that of Structured Query Language (SQL), which is used to retrieve and manipulate data in a relational database.

IBM Information Management System

IMSInformation Management SystemIMS/VS
Other forms of DML are those used by IMS/DLI, CODASYL databases, such as IDMS and others.

IDMS

CA IDMS
Other forms of DML are those used by IMS/DLI, CODASYL databases, such as IDMS and others.

Select (SQL)

SELECT keywordSELECTs
The SQL-data change statements are a subset of the SQL-data statements; this also contains the SELECT query statement, which strictly speaking is part of the DQL, not the DML.

Verb

verbsv.verbal morphology
Data manipulation languages have their functional capability organized by the initial word in a statement, which is almost always a verb.

Imperative programming

imperativeimperative programming languageimperative language
Most SQL database implementations extend their SQL capabilities by providing imperative, i.e. procedural languages.

IBM Db2 Family

DB2IBM DB2pureQuery
Examples of these are Oracle's PL/SQL and DB2's SQL_PL.

American National Standards Institute

ANSIASAAmerican National Standard
There have been a number of standards established for SQL by ANSI, but vendors still provide their own extensions to the standard while not implementing the entire standard.

Procedural programming

proceduralprocedural languageprocedural programming language
Data manipulation languages are divided into two types, procedural programming and declarative programming.

Declarative programming

declarativedeclarative languagedeclarative programming language
Data manipulation languages are divided into two types, procedural programming and declarative programming.

Computer program

programprogramscomputer programs
Data manipulation languages were initially only used within computer programs, but with the advent of SQL have come to be used interactively by database administrators.

Update (SQL)