mysql更新安全设置时出错_Mysql数据库更新字段时出错

Iam使用Java Swing应用程序更新Mysql表中的列。这是我的代码(部分)

String qunty = txtWithdraw.getText();

String partno = txtNo.getText();

int qty = Integer.parseInt(qunty);

con = DriverManager.getConnection(url + db, "username", "password");

Statement st = con.createStatement();

String sell = "update Store_info_table set qnty_received = qnty_received - " + qty + "where Part_number = '" + partno + "'";

st.executeUpdate(sell);我得到的例外是：

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 'Part_number = 'DF6534'' at line 1我想更新qnty_received字段，以便它等于原始值减去用户传递的值即(int qty)。我在做什么错误？