mysql 一次向表中插入多条数据实例讲解

CREATE TABLE Authors(AuthID SMALLINT NOT NULL PRIMARY KEY,AuthFN VARCHAR(20),AuthMN VARCHAR(20),AuthLN VARCHAR(20))ENGINE=INNODB;

INSERT INTO Authors VALUES (1006, 'H', 'S.', 'T'),              (1007, 'J', 'C', 'O'),              (1008, 'B', NULL, 'E'),              (1009, 'R', 'M', 'R'),              (1010, 'J', 'K', 'T'),              (1011, 'J', 'G.', 'N'),              (1012, 'A', NULL, 'P'),              (1013, 'A', NULL, 'W'),              (1014, 'N', NULL, 'A');