Important Operations of DML

Data manipulation language Commands (SELECT, INSERT, UPDATE and DELETE) and DML Operations (Insert data, Update data, Retrieve data and Deletes all records).
Post Reply
Gowtham Ramesh
Posts: 66
Joined: Thu Nov 22, 2018 5:23 am

Important Operations of DML

Post by Gowtham Ramesh » Wed Nov 28, 2018 11:23 am

What are the important operations of Data Manipulation Language?

David
Posts: 40
Joined: Wed Nov 28, 2018 1:06 pm

Re: Important Operations of DML

Post by David » Wed Nov 28, 2018 1:25 pm

DML is a subset of SQL, Data Manipulation Language commands are used to store, modify, retrieve, and delete data from database tables. In this category we have Select, Insert, Update, Delete Commands….

Important DML Commands are,
1) SELECT – Retrieves data from a table
2) INSERT – Inserts data into a table
3) UPDATE – Updates existing data into a table
4) DELETE – Deletes all records from a table

Note: SELECT command is important for Database Testing.

swathi
Posts: 134
Joined: Fri Nov 23, 2018 2:52 am

Re: Important Operations of DML

Post by swathi » Tue Dec 04, 2018 12:13 pm

DML (Data Manipulation Language): These statements are used to manipulate the data in records. Commonly used DML statements are Insert, Update, and Delete.

The Select statement is used as partial DML statement that is used to select all or relevant records in the table.

Post Reply

Return to “SQL - Data Manipulation Language”