Data Manipulation Language (DML)

There is a DDL, DML also there. DDL is Data Definition Language, while DML is Data Manipulation Language. Both are languages ​​which directly relate to the database. Data Manipulation Language (DML) is a language used to manipulate objects in a database. Language is a SQL language.

Examples of Data Manipulation Language (DML), among others:

• Insert command to insert new data into the database or databases. Example: INSERT INTO employees (no_pegawai, nama_pegawai) values ​​('P0001', 'ade');
• Update, the order to change the existing data in the database or databases. Example: UPDATE employees SET nama_pegawai = 'Dedek' WHERE no_pegawai = 1;
• Delete, command to erase the existing data in the database or databases. Example: DELETE FROM employees WHERE no_pegawai = 'P0001';
• Select, a command to display the data from the database, using either the condition or not. Example: SELECT * FROM employees; no_pegawai SELECT FROM employees;

That was a brief description of Data Manipulation Language (DML). If there are errors or omissions please added. For further details about the Select command by using the condition, I will discuss in another post. May be useful.