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

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')

最佳答案

ID 8是：

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

它似乎缺少结束语。

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

关于mysql - 为什么我不能在sql中的多行中插入数据？，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/39054757/