使用的python 库为MySQLdb
当执行excutemany 中sql语句为 on duplicate 时
正确的sql语句为:
insert into student(id,name) values(%s,%s) on duplicate key update name=values(name)
错误的sql语句为:
insert into student(id,name) values(%s,%s) on duplicate key update name=%s
正确的sql语句为:
delete_values=[]
delete_sql = "delete from fminfo WHERE infocode=%s"
delete_values.append((q['i_infoCode'],))
cur.executemany(delete_sql, delete_values)
错误的sql语句为( 注意tuple里面的逗号 ):
delete_values=[]
delete_sql = "delete from fminfo WHERE infocode=%s"
delete_values.append((q['i_infoCode']))
cur.executemany(delete_sql, delete_values)
否则会报错误not all arguments converted during string formating
但是如果使用的python 库位 pymysql
正确的写法是:
insert into student(id,name) values(%s,%s) on duplicate key update name=%s