mysql之1292


Look at this line “where PremiseID = “ + str(premiseID) + “ ; “])”. The comparison is happening on different types and when MySQL compares different datatypes they are cast to DOUBLE internally before comparison. So you can try putting single quote around or cast around to solve the issue. So it’s not try catch but the quotes which resolve the issue.