SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE my_table (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  data TEXT);
✓
INSERT INTO my_table (data) VALUES ('S1'), ('S2'), ('S3');
✓
SELECT * FROM my_table;


id
data


1
S1

2
S2

3
S3


DELETE FROM my_table WHERE id = 3;
✓
SELECT * FROM my_table;


id
data


1
S1

2
S2


INSERT INTO my_table DEFAULT VALUES;
✓
SELECT * FROM my_table;


id
data


1
S1

2
S2

4
null

id	data
1	S1
2	S2
4	null