Snippet

Inserting New Rows into a Table with INSERT INTO

The INSERT INTO statement adds new data records into a table. You list the target columns followed by the matching values in the VALUES clause.

snippet.sql

sql

INSERT INTO customers (customer_name, email)
VALUES ('Alice Smith', '[email protected]');

Breakdown

INSERT INTO customers (customer_name, email)

Specifies the target table 'customers' and the columns receiving new values.

VALUES ('Alice Smith', '[email protected]');

Provides the literal data values corresponding to each specified column.