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