SQL Syntax error when running DELETE from Java

Question

I get error ERROR: syntax error at or near "("

String deleteSQL = "DELETE FROM customer" +
"WHERE (fname = 'Fred' AND lname = 'Flintstone')" +
"OR (fname = 'Barney' AND lname = 'Rubble')";
System.out.println("Records deleted: "
+ stmt.executeUpdate(deleteSQL));

You could have easily solved this problem yourself my merely examining deleteSQL with the debugger. — Tony Ennis
– Tony Ennis, Commented Nov 2, 2013 at 13:58

Langusten Gustel · Accepted Answer · 2013-11-02 13:41:06Z

5

String deleteSQL = "DELETE FROM customer " +
"WHERE (fname = 'Fred' AND lname = 'Flintstone') " +
"OR (fname = 'Barney' AND lname = 'Rubble') ";
System.out.println("Records deleted: "
+ stmt.executeUpdate(deleteSQL));

The problem are the missing spaces while concatinating.

Imagine the following:

"word" + "word2"

this would result "wordword2"

so it should be

"word" + " " + "word2" or "word "+ "word2"

edited Nov 2, 2013 at 13:41

answered Nov 2, 2013 at 13:39

Langusten Gustel

11k9 gold badges48 silver badges62 bronze badges

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

1 Comment

Yenots1 Over a year ago

Jup. That was it :) +

Collectives™ on Stack Overflow

SQL Syntax error when running DELETE from Java

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related