What is Data Manipulation Language in MySql

Data Manipulation Language (DML) is the syntax elements similar to a computer programming language used for selecting, inserting, deleting and updating data in a database.

• 1- insert(inserts one or more values into a table)

INSERT INTO table_name
    VALUES (value 1, ... value n);

• 2- update (updates one or more attributes in a table)

UPDATE table_name
    SET attribute = expression
       WHERE condition;

• 3- delete (deletes a record from a table)

DELETE FROM table_name
    WHERE condition;