By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Fooey(SomeInteger INTEGER PRIMARY KEY);
INSERT INTO Fooey(SomeINteger) VALUES (NULL);
Column 'SomeInteger' cannot be null
INSERT INTO Fooey(SomeINteger) VALUES (NULL);
Column 'SomeInteger' cannot be null
select * from Fooey;
| SomeInteger |
|---|
INSERT INTO Fooey(SomeInteger) VALUES (33);
INSERT INTO Fooey(SomeInteger) VALUES (44);
INSERT INTO Fooey(SomeInteger) VALUES (33);
Duplicate entry '33' for key 'Fooey.PRIMARY'
select * from Fooey;
| SomeInteger |
|---|
| 33 |
| 44 |
INSERT INTO Fooey(SomeINteger) VALUES (NULL);
INSERT INTO Fooey(SomeINteger) VALUES (NULL);
INSERT INTO Fooey(SomeINteger) VALUES (NULL);
INSERT INTO Fooey(SomeINteger) VALUES (NULL);
INSERT INTO Fooey(SomeINteger) VALUES (NULL);
Column 'SomeInteger' cannot be null
select * from Fooey;
| SomeInteger |
|---|
| 33 |
| 44 |