Syntax error in delete statement

Question

I am trying to delete the record from my "student" table, the table has two column rollno and student name.

I am using a PreparedStatement but I am getting some error. I could not understand the error. The error is:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1

here is my code

    String query = "delete from student where rollno = ?";

    PreparedStatement pst = con.prepareStatement(query);

      pst.setInt(1, 7);
     pst.executeUpdate(query);

You forgot to share the most important part: How do you execute the query? — BackSlash
– BackSlash, Commented May 28, 2017 at 15:21

BackSlash · Accepted Answer · 2017-05-28 15:22:52Z

3

Likely you are calling the execute like this:

pst.executeUpdate(query);

This will execute the raw query, without the parameter you set before.

You want to execute the prepared query instead, so just use:

pst.executeUpdate();

answered May 28, 2017 at 15:22

BackSlash

22.3k25 gold badges103 silver badges143 bronze badges

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

Collectives™ on Stack Overflow

Syntax error in delete statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related