6. DML – Data Manipulation Language

Add Data

-- Add data for fixed columns.
INSERT INTO tableName (column1,column1,...) VALUES(value1,value2,...);

-- Add data for whole columns
INSERT INTO tableName VALUES(value1,value2,...);

-- Add multiple data
INSERT INTO tableName (column1,column2,...) VALUES(value1,value2,...),(value1,value2,...);

INSERT INTO VALUES(value1,value2,...),(value1,value2,...);

Update Data

UPDATE tableName SET column1 = value1,column2 = value2,... [WHERE condition];

-- Example
UPDATE users SET name = 'Mr.li' WHERE id = 2;

Delete Data

DELETE FROM tableName [WHERE condition];

-- Example
DELETE FROM users where id = 1;

Check Data

SELECT * FROM tableName;