DML (Data Manipulation Language) commands in SQL are used to manage data within the tables. These commands allow you to insert, update, delete, and retrieve data.

? Main DML Commands:

? 1. SELECT

Used to fetch data from a database.

SELECT * FROM employees;SELECT name, salary FROM employees WHERE department = 'HR';

? 2. INSERT

Adds new rows to a table.

INSERT INTO employees (name, department, salary)VALUES ('John Doe', 'Sales', 45000);

? 3. UPDATE

Modifies existing records.

UPDATE employeesSET salary = 50000WHERE name = 'John Doe';

? 4. DELETE

Removes existing records.

DELETE FROM employeesWHERE name = 'John Doe';

?? Note:

• DML operations can be rolled back using the ROLLBACK command.

• They are transactional, which means you can use BEGIN TRANSACTION, COMMIT, and ROLLBACK.

Would you like examples with a specific database table or use case?