格式:
"'"+插入的数据+"'"
例子:
for i in range(10): tNumDet = str(i) k = "hanchao" sqla = 'insert into student values(%s,%s);' %(i,"'"+ k+tNumDet +"'") cur.execute(sqla) connect.commit()
完美解决
格式:
"'"+插入的数据+"'"
例子:
for i in range(10): tNumDet = str(i) k = "hanchao" sqla = 'insert into student values(%s,%s);' %(i,"'"+ k+tNumDet +"'") cur.execute(sqla) connect.commit()
完美解决