I have an incorrect syntax error

Question

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

In this code, the first line of code works just fine, but when I type up the second line of code with the same person name, it doesn't accept it.

This is the error that I receive:

Msg 102, Level 15, State 1, Line 5
Incorrect syntax near 'John'.

Seems like this one answered your question. Please mark it as answered. http://stackoverflow.com/questions/23164151/insert-into-statement-in-sql-server — Nick.Mc, Apr 19 '14 at 07:21

Karl Kieninger · Answer 1 · 2016-08-12T13:23:49.653

5

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

edited Aug 12 '16 at 13:23

answered Apr 19 '14 at 02:43

Karl Kieninger

8,841
2
33
49

score 2 · Answer 2 · answered Apr 19 '14 at 02:49

As @helderdarocha and @Karl Kieninger said you are missing a comma between the tuples or if you still cant resolve the issue, try writing individual entries....I can`t think of anything else possible...

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

I have an incorrect syntax error

2 Answers2