在使用pymysql时,执行完成后,看到有warning错误信息:
Warning: (1292, "Truncated incorrect DOUBLE value: 'policeman1'")
执行的sql语句:delete from police_user where account_number=500514;
后来查看表的字段属性,发现account_number是varchar类型,而sql中的类型是int类型,导致报错
修改sql语句后问题解决:delete from police_user where account_number="500514";