mySQL query gives syntax error in java, but works fine in mySQL workbench

Question

I'm trying to execute the sql query:

INSERT INTO celebrity (name, `1`, `15`, `3`, `20`, `4`, `13`, `35`, `22`, `6`, `19`) VALUES ("Keith Allen", 1, 1, 1, 1, 1, -1, -1, -1, -1, 1)

which worked fine in the workbench and correctly added the new row, however when I call the same query from java using the executeUpdate(String query) method, I get a sql syntax error

The ` character is there so sql can tell that 1 is the name of a column and not just an integer. I was using ' before and I was getting syntax errors — Andrew Brick
– Andrew Brick, Commented Mar 30, 2015 at 7:08

Tim Biegeleisen · Accepted Answer · 2015-03-30 06:54:23Z

2

You need to escape your double quotes like this:

INSERT INTO celebrity (name, `1`, `15`, `3`, `20`, `4`, `13`, `35`, `22`, `6`, `19`)
VALUES (\"Keith Allen\", 1, 1, 1, 1, 1, -1, -1, -1, -1, 1)

answered Mar 30, 2015 at 6:54

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

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

Collectives™ on Stack Overflow

mySQL query gives syntax error in java, but works fine in mySQL workbench

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related