By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tablename(col1 TEXT, col2 TEXT, ID INTEGER PRIMARY KEY AUTOINCREMENT);
INSERT INTO tablename VALUES('value1', 'value2', NULL);
SELECT * FROM tablename;
| col1 | col2 | ID |
|---|---|---|
| value1 | value2 | 1 |
INSERT INTO tablename VALUES('value3', 'value4', NULL);
SELECT * FROM tablename;
| col1 | col2 | ID |
|---|---|---|
| value1 | value2 | 1 |
| value3 | value4 | 2 |