How to Insert One or More Rows in SQL

You use the INSERT INTO statement to add new rows to a table.

1. Insert One Row

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

Example:

INSERT INTO employees (employee_id, name, department)VALUES (101, 'John Doe', 'Sales');

2. Insert Multiple Rows at Once

INSERT INTO table_name (column1, column2, column3)VALUES     (value1a, value2a, value3a),    (value1b, value2b, value3b),    (value1c, value2c, value3c);

Example:

INSERT INTO employees (employee_id, name, department)VALUES    (102, 'Jane Smith', 'Marketing'),    (103, 'Bob Johnson', 'IT'),    (104, 'Alice Williams', 'HR');

Notes:

• Column list (column1, column2, ...) is optional if you provide values for all columns in the correct order.

• Make sure the values match the data types and constraints of the columns.

• You can insert from another table using INSERT INTO ... SELECT ... if needed.

If you want, I can show you examples for your specific database or table!