By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 10.4.10-MariaDB-1:10.4.10+maria~buster |
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');
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;
Unknown storage engine 'BLACKHOLE'
INSTALL SONAME 'ha_blackhole';
INSERT command denied to user 'fiddle_MGPIUXMGLOYFHIXQFBDK'@'localhost' for table 'plugin'
INSERT INTO foo (baz) VALUES ('xxxxx'), ('yyyyy'), ('zzzzzzz');
SELECT * FROM foo;
| bar | baz |
|---|---|
| 1 | afadfa |
| 2 | sfasdfa |
| 3 | asdfadf |
| 4 | xxxxx |
| 5 | yyyyy |
| 6 | zzzzzzz |
INSERT INTO foo (baz) VALUES (23, 'asdfds'), (33), (43, 'adsfd');
Column count doesn't match value count at row 1