Answer
INSERT adds new rows to a table. • A column list makes the value-to-column mapping explicit. • Values can come from VALUES or from a query. • Constraints are checked before the new row is accepted.
💡 SQL Example
INSERT INTO departments (department_id, name)
VALUES (10, 'Engineering');
Result
INSERT 0 1
⚡ Quick Revision
INSERT creates new table rows.