DCL (Data Control Language) 4. TCL (Transaction Control Language) DML (Data Manipulation Language) DML statements affect records in a table. These are basic operations we perform on data such as selecting a few records from a table, inserting new records, deleting unnecessary records, and updating/modifying existing records.
A data manipulation language (DML) is a family of computer languages including commands permitting users to manipulate data in a database. This manipulation involves inserting data into database tables, retrieving existing data, deleting data from existing tables and modifying existing data.
Data Query Language To retrieve, INSERT, DELETE and modify data in the PointBase RDBMS, use the Data Manipulation Language (DML) and Data Query Language (DQL). DML and DQL allows an application to do the following: SELECT: Retrieve rows of data. INSERT: Place new rows of data in the database. UPDATE: Replace existing values in the database with new values.
SQL language is divided into four types of primary language statements: DML, DDL, DCL and TCL. Using these statements, we can define the structure of a database by creating and altering database objects, and we can manipulate data in a table through updates or deletions.