Y3izUquf

1CREATE TABLE IF NOT EXISTS tbl_authors(ID_Author SMALLINT PRIMARY KEY, Name_Author VARCHAR(50) NOT NULL, LastName_Author VARCHAR(60) NOT NULL DEFAULT 'Smith');
2INSERT INTO tbl_authors VALUES(1, 'Daniel', 'Barret'), (2, 'Gerald', 'Carter'), (3, 'Mark', 'Sobell'), (4, 'William', 'Stanek'), (5, 'Richard', 'Blum'), (6, 'Jostein', 'Gaarder'), (7, 'Umberto', 'Eco'), (8, 'Neil', 'De Grasse Tyson'), (9, 'Stephen', 'Hawking'), (10, 'Stephen', 'Jay Gould'), (11, 'Charles', 'Darwin'), (12, 'Alan', 'Turing'), (13, 'Simon', 'Monk'), (14, 'Paul', 'Scherz');
3INSERT INTO tbl_authors VALUES(15, 'Noah');
4ERROR 1136 (21S01): Column count doesn't match value count at row 1