DML is a computer language used for the retrieval, insertion, deletion and modification of the information. The regular users use number of commands DML commands as they use the system regularly. The details of the commands are as follows:

Insert
This command is used to add data into to the existing record or table. The command used is directly related to the kind of information added. For e.g.: if the information about the educational qualifications of an employee is to be added; the command says: INSERT INTO educational_ qualifications values ('xyz','abc', BA, MA). It is mandatory that the number of column should be same. Every column has a detail in it. In the above e.g. the firs column details about employee’s first name, second column says about employee’s last name and last column says about the qualifications. If in case any error occurs or if any command is added in a wrong row or wrong column, the new row is not added in the table and the error remains the as it is. In SQL the insertion command is used to insert as many rows or columns one desires; but the main criteria is that the details mentioned should correspond with the rows and the columns added.

Select
Select command is the most frequently used DML command. With the help of this command the user can easily retrieve any special information which he desires. For e.g. the Accounts Department requires the employee information and specifically the employee code they can easily retrieve the information by adding: SELECT employee_code FROM employee_information.

Update
This command can be used for modification of any kind of information, either in one single row or column. For e.g. if the Accounts department has to add the details of the change in salary they can use the following details:
Update Set Salary Increment=
UPDATE employee_informaiton
SET salary = salary + $2000
WHERE employee_id = 0123

Delete
The syntax of the delete command is similar to as of the other commands. This can be easily used to delete the details of any employee from the official records. This kind of deletion is only possible when the employee has left the company and the profile has to be deleted. The command which can be used for the deletion may be:
DELETE FROM employee_infomation
WHERE employee_id = 0123

Everyday a new technology is upgraded so as the computer languages.