# Data Manipulation Language

# [Lecture] DML (Data Manipulation Language)

The DML (Data Manipulation Language) is concerned with inserting and updating and deleting of data in tables.

# [Lecture] Insert Data into Tables

INSERT INTO <TABLE_NAME> (<COLUMN1>, <COLUMN2>, ...)
VALUES ('VALUE1', 'VALUE2', ...);

# [Lecture] Updating Data in Tables

UPDATE <TABLE_NAME>
SET <COLUMN_NAME> = 'VALUE'
WHERE <COLUMN_NAME> = 'VALUE';

# [Lecture] Deleting Data from Tables

DELETE FROM <TABLE_NAME>
WHERE <COLUMN_NAME> = 'VALUE';
Last Updated: 12/15/2020, 10:27:30 PM