python向数据库中添加参数_python中向mysql数据库插入变量

list=[].........................sql="selectstudent.idfromstudent"cursor.execute(sql)data=cursor.fetchone()whiledata!=None:...............sql="insertcensorvaules("+data[0]...

list=[]

.........................

sql="select student.id from student"

cursor.execute(sql)

data = cursor.fetchone()

while data!=None:

...............

sql="insert censor vaules("+data[0]+","+list[i]+",'开机的流程')"

...............

最后一句报错TypeError: cannot concatenate(链接) 'str' and 'long' objects

如何如何改才能正确打印出sql

展开