在执行insert操作中,报错“no such table”
报错时的代码:
cursor.execute("insert into inandoutadd (keyid,goip,status,addtime,runtime) values ("+keyid+","+goip+","+status+","+addtime+","+runtime+")")
修改后的代码
cursor.execute("insert into inandoutadd (keyid,goip,status,addtime,runtime) values ('%s','%s','%s','%s','%s')"%(keyid,goip,status,addtime,runtime))
修改后执行没有报错