· 8 years ago · Apr 08, 2018, 01:16 PM
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(ID_Author, Name_Author, LastName_Author) 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'), (15, 'Noah');
3ERROR 1136 (21S01): Column count doesn't match value count at row 15