mysql - 为什么sql中不能插入多行数据？

Question

INSERT INTO doctor (doc_id,doc_name,doc_speciality,doc_available,doc_info) values
    (5,'Jack Racheal','Gastric','yes','No one'),
    (6,'Yara Greyjoy','Respiratory problems','yes','Daughter of Balon Greyjoy'),
    (7,'Jared','Cancer','yes','Mastermind behing the Silicon Valley'),
    (8,'Avaiato','Respiratory problems','yes','Daughter of Howland Reed',
    (9,'Leo DiCaprio','Diabetes','yes','Django Unchained'),
    (10,'Danerys Targareyan','Respiratory problems','yes','Mother of Dragons'),
    (11,'Jon Snow','Jaundice','yes','Knows nothing'),
    (12,'Tyrion Lannister','Typhoid','yes','Knows something when he drinks'),
    (13,'Samwell Tarly','Gastric','yes','Step father of baby sam'),
    (14,'Cateyln Tully','Respiratory problems','yes','Red wedding'),
    (15,'Sandors Clegane','T.B','yes','The hound'),
    (16,'Arya Stark','Cholera','yes','The girl has no name')

Answer 1

id 8 是:

(8,'Avaiato','Respiratory problems','yes','Daughter of Howland Reed',

它似乎缺少一个右括号。

(8,'Avaiato','Respiratory problems','yes','Daughter of Howland Reed'),