By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 8.0.18 |
CREATE TABLE foo
(
bar INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
baz VARCHAR (30) NOT NULL
) ENGINE = InnoDB;
INSERT INTO foo (baz) VALUES ('afadfa'), ('sfasdfa'), ('asdfadf');
INSERT INTO foo (baz) VALUES (23, 'asdfds'), (33), (43, 'adsfd');
-- Error: to be expected
Column count doesn't match value count at row 1
SELECT * FROM foo;
| bar | baz |
|---|---|
| 1 | afadfa |
| 2 | sfasdfa |
| 3 | asdfadf |
ALTER TABLE foo ENGINE = BLACKHOLE;
INSERT INTO foo (baz) VALUES ('xxxxx'), ('yyyyy'), ('zzzzzzz');
SELECT * FROM foo;
INSERT INTO foo (baz) VALUES (23, 'asdfds'), (33), (43, 'adsfd');
-- To external agents, all appears normal even though the data is not being stored!
Column count doesn't match value count at row 1