I have an incorrect syntax error

This question already has an answer here:

Inserting multiple rows in a single SQL query? [duplicate] 4 answers

---

For the sake of having an answer rather than a comment. Exactly as @helderdarocha said, "You are missing a comma in between the lines."

INSERT INTO FoodLog (Person,Food,ServingSize,Date,Meal)
VALUES ('John','Cheerios',2,'1-APR-2014','Breakfast')
      ,('John','TBoneSteak',1,'2-APR-2014','Lunch')

---

正如@helderdarocha和@Karl Kieninger所说，你错过了元组之间的逗号，或者如果你仍然无法解决问题，请尝试写入单个条目....我不能想到其他任何可能的事情......

    INSERT INTO FoodLog VALUES ('John','Cheerios',2,'1-APR-2014','Breakfast');
    INSERT INTO FoodLog VALUES ('John','TBoneSteak',1,'2-APR-2014','Lunch');

链接地址: http://www.djcxy.com/p/94496.html

上一篇: 如何批量插入数据？

下一篇: 我有一个不正确的语法错误