java.sql.SQLSyntaxError at INSERT Statement

Question

I am currently filling my hsql db with an insert Statement, but it doesn`t work and I cannot see the mistake...

here are my INSERT statements:

INSERT INTO Waren VALUES(name, kategorie, geloescht, haltbar, preis, altersfreigabe) VALUES
('Schnitzel', 'Speisen', FALSE, 'TRUE', 1.20, 0);
INSERT INTO Waren VALUES('Apfel', 'Speisen', FALSE, 'TRUE', 2.00, 0);
INSERT INTO Waren VALUES ('Kokosnüsse', 'Speisen', FALSE, 'TRUE', 1.00, 0);
INSERT INTO Waren VALUES('Suppe', 'Speisen', FALSE, 'TRUE', 2.00, 0);
INSERT INTO Waren VALUES('Karotte', 'Speisen', FALSE, 'TRUE', 1.00, 0);
INSERT INTO Waren VALUES('Kaiserschmarn', 'Speisen', FALSE, 'TRUE', 2.90, 0);
INSERT INTO Waren VALUES('Schnaps', 'Getraenke', FALSE, 'TRUE', 2.90, 18);
INSERT INTO Waren VALUES('Cola Rum', 'Getraenke', FALSE, 'TRUE', 2.70, 18);
INSERT INTO Waren VALUES('Wein', 'Getraenke', FALSE, 'TRUE', 1.20, 18);
INSERT INTO Waren VALUES('Bier', 'Getraenke', FALSE, 'TRUE', 3.00, 16);
INSERT INTO Waren VALUES('Dead Killer Drink', 'Getraenke', FALSE, 'TRUE', 7.00, 18);

I appreciate your answer!!!

what's the error you're getting?

Will
– Will

2012-09-21 13:00:54 +00:00
Commented Sep 21, 2012 at 13:00 — Will
– Will, Commented Sep 21, 2012 at 13:00

Eng.Fouad · Accepted Answer · 2012-09-21 13:01:08Z

4

Remove the first VALUES:

INSERT INTO Waren (name, kategorie, geloescht, haltbar, preis, altersfreigabe) VALUES
('Schnitzel', 'Speisen', FALSE, 'TRUE', 1.20, 0);

answered Sep 21, 2012 at 13:01

Eng.Fouad

118k75 gold badges326 silver badges431 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Anirudh Ramanathan · Accepted Answer · 2012-09-21 23:30:47Z

1

I think you have a VALUES too much.

INSERT INTO Waren **VALUES**(name, kategorie, ...

should be removed.

edited Sep 21, 2012 at 23:30

Anirudh Ramanathan

46.8k24 gold badges137 silver badges195 bronze badges

answered Sep 21, 2012 at 13:02

Will

3,0088 gold badges37 silver badges50 bronze badges

Collectives™ on Stack Overflow

java.sql.SQLSyntaxError at INSERT Statement

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related