Insert a Row

Add new data to a table, then verify the inserted row with a deterministic query.

5/5 supported engines validation-green 1 example 2 scenarios

Docker-validated Not currently validation-green

Example 1

Insert one row and read it back

This example focuses on the table state after insertion rather than the command status message, which can differ more across engines and drivers.

MySQL MariaDB SQLite

Engine-specific syntax

Source table data

Setup

CREATE TABLE projects (id INT, name VARCHAR(50));

INSERT INTO
  projects (id, name)
VALUES
  (1, 'Atlas');

Validated query

SQL

INSERT INTO
  projects (id, name)
VALUES
  (2, 'Beacon');

SELECT
  id,
  name
FROM
  projects
ORDER BY
  id;

Expected result

id	name
1	Atlas
2	Beacon

SQL Server PostgreSQL

Engine-specific syntax

Source table data

Setup

CREATE TABLE projects (id INT, name VARCHAR(50));

INSERT INTO
  projects (id, name)
VALUES
  (1, 'Atlas');

INSERT INTO
  projects (id, name)
VALUES
  (2, 'Beacon');

Validated query

SQL

SELECT
  id,
  name
FROM
  projects
ORDER BY
  id;

Expected result

id	name
1	Atlas
2	Beacon

The verification output is the same, but the executable setup and run blocks differ to keep the captured result deterministic.

Useful when

Where this command helps.

creating a new business record from application input
seeding a small dataset for a later query example

Explanation

What the command is doing.

Use INSERT INTO ... VALUES (...) to create new rows. For teaching content, follow the insert with a simple SELECT so readers can see the resulting state clearly.

Insert a Row

Insert one row and read it back

Where this command helps.

What the command is doing.

Keep moving through nearby tasks.