Data Manipulation Language (DML)

INSERT Statement

Single Row

INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, ...);

Multiple Rows

INSERT INTO table_name (column1, column2, ...)
VALUES
  (value1a, value2a, ...),
  (value1b, value2b, ...);

UPDATE Statement

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

DELETE Statement

DELETE FROM table_name
WHERE condition;

Examples

Insert Employee

INSERT INTO employees (employee_id, first_name, last_name, email)
VALUES (1, 'John', 'Doe', 'john.doe@company.com');

Update Salary

UPDATE employees
SET salary = 75000
WHERE employee_id = 1;

Delete Employee

DELETE FROM employees
WHERE employee_id = 1;

Best Practices

• Always use WHERE clause with UPDATE/DELETE
• Test with SELECT before UPDATE/DELETE
• Use transactions for critical operations
• Backup data before major changes