By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tmp(
id INTEGER PRIMARY KEY AUTOINCREMENT,
name VARCHAR(45) DEFAULT NULL
);
INSERT INTO tmp(name)
VALUES('test 1'),
('test 2'),
('test 3');
INSERT INTO tmp(id,name)
VALUES(0, 'test X');
SELECT
*
FROM
tmp;;
id | name |
---|---|
0 | test X |
1 | test 1 |
2 | test 2 |
3 | test 3 |