Create a table and insert its first row.
SQLite: Define column types and a primary key, then insert one row using an explicit column list.
CREATE TABLE lessons (id INTEGER PRIMARY KEY, title VARCHAR(40) NOT NULL);
INSERT INTO lessons (id, title) VALUES (1, 'First lesson');
SELECT id, title FROM lessons;Expected output EXAMPLE
1|First lesson
Details
Requires SQLite 3.40 or later. Run with sqlite3 demo.db in a scratch directory. Result rows below use | between columns, without headers; client display formatting may differ.
Run each example independently in an empty scratch database or schema; the example includes its own starting table and rows.
Tested on Ubuntu 24.04.5 LTS · · SQLite 3.45.1 · bash 5.2.21-2ubuntu4; coreutils 9.4-3ubuntu6.3
Test inputs, results and environment
The exact published code ran in a dedicated Linux test container with prepared inputs. Snippet process uid 65534 with a read-only root filesystem and temporary working files. Networking disabled. Fixtures and output records are isolated from the application database. Testing covers this example and its stated checks, not every input, operating system, or runtime version. The Linux container shares its host's kernel; this is not a native Windows test.
- Architecture / host kernel
- x86_64 / 6.18.54.1-microsoft-standard-WSL2
- Snippet identity / locale
- uid=65534, gid=65534 (unprivileged process) / C.UTF-8
- Interpreter invocation
Execute the exact SQL in a fresh database/schema; serialize result rows with | separators- Container image ID
sha256:ec91410a8f6ec3e985830b5e3a0560306d36f8c1c5ccd91a6699abe707123fa3- Code SHA-256
5263443115c8d8de8344e6c4f06bfac01a9d509971b2894fbc4c954960e5fbe8- Dependencies
- bash 5.2.21-2ubuntu4; coreutils 9.4-3ubuntu6.3
Test input setup
These are the prepared inputs used by the test harness. See Details above for the prerequisites and how to run this example.
# No input files required.
Observed standard output
1|First lesson
Exit code: 0. Standard error: empty. Validation: Exact stdout comparison. System-dependent values above are one recorded run.