INSERT INTO

The INSERT INTO statement is used to add new records to an existing table in SQL. Each new row you insert becomes a part of the table's dataset.

The example below shows how to insert a new row into a table using the INSERT INTO statement:

Copy
INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, ...);

• table_name is the name of the table.
• (column1, column2, ...) lists the columns you want to insert data into.
• VALUES (...) provides the values to store.

Please note that the number of values you provide must match the number of columns specified in the column list.

The query below adds a new row for a client named Laura Adams.

Copy
INSERT INTO clients (id, name, email, signup_date)
VALUES (4, 'Laura Adams', 'laura.adams@example.com', '2023-03-05');

The result will be:

If you provide values for all columns in the correct order, you can omit the column list:

Copy
INSERT INTO clients
VALUES (5, 'Jason Green', 'jason.green@example.com', '2023-12-14');

Be careful: this only works if you supply values for every column in the correct sequence.

In the next lesson, you'll learn how to update existing data using the UPDATE command.