INSERT INTO

INSERT INTO is a SQL statement in the DML Statements category. Inserts new rows into a table. The syntax is INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);. It returns number of rows inserted. A typical example: INSERT INTO employees (name, email, salary) VALUES ('Alice', 'alice@example.com', 75000); -- Insert multiple rows: INSERT INTO products (name, price) VALUES ('Laptop', 999), ('Mouse', 25); A close relative is UPDATE, which modifies existing rows in a table. Always use WHERE to avoid updating all rows. A close relative is DELETE, which removes rows from a table. Always use WHERE to avoid deleting all rows. A close relative is REPLACE INTO, which iNSERT, but if a UNIQUE/PRIMARY KEY conflict exists, DELETES the old row and inserts a new one. MySQL-specific. More about this category: Data Manipulation Language — INSERT, UPDATE, DELETE, REPLACE, MERGE. Related DML Statements entries: UPDATE, DELETE, REPLACE INTO, INSERT ... ON DUPLICATE KEY UPDATE, MERGE, INSERT INTO SELECT, UPSERT (PostgreSQL), DELETE with JOIN.