vendredi 22 juillet 2016

What is wrong with the following query giving me SQL exception? [on hold]

the following query is giving me Exception
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'equipcompany.NEquipments=equipcompany.NEquipments+100 WHERE equipments.EId=25 An' at line 1

 String query="UPDATE equipments, equipcompany SET equipments.Econdition=? 
equipcompany.NEquipments=equipcompany.NEquipments+? WHERE equipments.EId=? And 
 equipcompany.Eid=?;";

Aucun commentaire:

Enregistrer un commentaire