mysql和sqlite3多次查询问题，搞了几次没搞定

[liwan123]

两个mysql表：table1，table2，两个表的id值相同，目的是从mysql表table1中查出数据，然后在sqlite3的表table3中查出和mysql的table1具有相同biaoti 、company 、kanwu值的字段filename，再用filename的值去更新mysql表table2中downpath值，现在第一步已经完成，最后一步更新table2的downpath值提示错误，很奇怪，TypeError: not all arguments converted during string formatting

import time
import urllib.request
import urllib.parse
import sqlite3
import pymysql

if __name__ == "__main__":
    connmysql = pymysql.connect(user='root', password='123456', database='empiredd', charset='utf8')
    cursormysql = connmysql.cursor()
    query = 'select id, title , company, qikanname from table1'
    cursormysql.execute(query)
    for (id, title, company, qikanname) in cursormysql:
        print(id, title, company, qikanname)       
        conn = sqlite3.connect(r"E:\网站\SpiderResult.db3")
        cursor = conn.cursor()
        sql = "select filename from table3 where biaoti = ? and company = ? and kanwu = ?"
        cursor.execute(sql, (title, company, qikanname))
        values = cursor.fetchone()
        print(values[0])
        print(id)
       cursormysql.execute('update table2  set downpath = ? where id = ?', (values[0], id))
        connmysql.commit()
    cursor.close()
    conn.close()
    cursormysql.close()
    connmysql.close()

错误提示是cursormysql.execute('update table2 set downpath = ? where id = ?', (values[0], id))，很奇怪

[liwan123]

网站好像自动转码了，源代码如下： import time import urllib.request import urllib.parse import sqlite3 import pymysql if __name__ == "__main__": connmysql = pymysql.connect(user='root', password='123456', database='empiredd', charset='utf8') cursormysql = connmysql.cursor() query = 'select id, title , company, qikanname from table1' cursormysql.execute(query) for (id, title, company, qikanname) in cursormysql: print(id, title, company, qikanname) conn = sqlite3.connect(r"E:\网站\SpiderResult.db3") cursor = conn.cursor() sql = "select filename from table3 where biaoti = ? and company = ? and kanwu = ?" cursor.execute(sql, (title, company, qikanname)) values = cursor.fetchone() print(values[0]) print(id) cursormysql.execute('update table2 set downpath = ? where id = ?', (values[0], id)) connmysql.commit() cursor.close() conn.close() cursormysql.close() connmysql.close()

[liwan123]

print(values[0]) 的结果是str类型，值为wxrokl4xnp2.pdf print(id)的结果是60，这两个值都是正确的，

[陈年椰子]

cursormysql.execute('update table2 set downpath = ? where id = ?', (values[0], id)) 改成 cursormysql.execute('update table2 set downpath = ? where id = ?', (values[0][0], id)) 因为 values[0] 是 结果集的第一条记录。 values[0][0] 才是第一条记录的 filename 字段的值。

[冰风漫天]

按道理不应该报错，你把?换成%s看看，还有把完整的错误信息再发一下