🧾 DML (Data Manipulation Language) in SQL

Last Updated: January 2026

DML (Data Manipulation Language) is a category of SQL commands used to work with the data inside tables.

👉 DML commands do not change table structure, they only manipulate rows (records).

  • Insert new data
  • Update data
  • Delete data

Hinglish Tip 🗣: Table ke andar ka data handle karna ho → DML commands use hote hain.

🧩 DML Commands

We will cover each command in a separate tutorial. Here is just the big picture 👇

INSERT

  • Used to add new rows into a table
INSERT INTO table_name VALUES (...);

UPDATE

  • Used to modify existing data
UPDATE table_name SET column = value;

DELETE

  • Used to remove rows from a table
DELETE FROM table_name;

⚠️ Important Notes About DML

  • DML commands affect table data
  • They are usually transaction-controlled
  • Can be rolled back (if transaction supported)
  • WHERE clause is critical for safety

Hinglish Tip 🗣: > WHERE na lagaya to poora data change / delete ho sakta hai.

← PreviousNext →