MySql Update Error Java

Question

I am trying to Update a table in mysql and this is the code:

            PreparedStatement ps = con.prepareStatement("UPDATE PbnNumberPlayer SET jointime=?, unique=? WHERE server=?");
            ps.setInt(1, jointime);
            ps.setInt(2, unique);
            ps.setString(3, name);

            ps.executeUpdate();
            ps.close();

The error that I got is:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'unique=0 WHERE server='pbns4'' at line 1

We would need to see the entire code block to determine where the issue is. For example, there is no way of understanding what values jointime, unique or name have at the moment. Please post the entire section of code. — dat3450
– dat3450, Commented Mar 2, 2017 at 4:36
Maybe try ps.executeQuery(); instead of ps.executeUpdate(); as well. — dat3450
– dat3450, Commented Mar 2, 2017 at 4:38
ps.executeUpdate(); is what you want to use. Check the contents of the name variable. It looks like you have a problem there. As a matter of fact, check the contents of all your variables. Make sure they contain what you might expect. — DevilsHnd - 退した
– DevilsHnd - 退した, Commented Mar 2, 2017 at 4:56

denny · Accepted Answer · 2017-03-02 06:11:25Z

1

put backticks in query cause unique is reserved keywork in mysql

PreparedStatement ps = con.prepareStatement("UPDATE PbnNumberPlayer SET `jointime`=?, `unique`=? WHERE `server`=?");

read here for more reference here

answered Mar 2, 2017 at 6:11

denny

2,2942 gold badges18 silver badges21 bronze badges

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

1 Comment

Mukri Over a year ago

Thank you so much! +1 Weird thing is, my other code is working perfectly without those. But now, im gonna add them just in case.

Collectives™ on Stack Overflow

MySql Update Error 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