The difference between the (DDL AND DML) DATABASE

DDL(Data Definition Language) and DML(Data Manipulation Language) are two important subsets of SQL (Structured Query Language), each serving different purposes in database management.

• DDL

1. CREATE: To create new tables or databases.

CREATE TABLE Employees (
    ID INT PRIMARY KEY,
    Name VARCHAR(100),
    Position VARCHAR(50)
);

1. ALTER: To modify existing database structures (e.g., adding or dropping columns).

ALTER TABLE table_name
ADD column_name data_type;

1. DROP: To delete tables or databases.

DROP TABLE table_name;

---

DML

1. SELECT: To query and retrieve data.

SELECT column1, column2, ...
FROM table_name;

1. INSERT: To add new records to a table.

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

1. UPDATE: To modify existing records.

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

1. DELETE: To remove records from a table.

DELETE FROM table_name
WHERE condition;