pyside6使用qsql批量execBatch写入数据报错
No data supplied for parameters in prepared statement QMYSQL: Unable to execute statement
sql =f"INSERT IGNORE INTO `{table_name}` (`url`, `creat_time`) VALUES (:url, :creat_time)"
#sql =f"INSERT IGNORE INTO {table_name} (url, creat_time) VALUES (?,?)"
query = QSqlQuery(db)
query.prepare(sql)
for url in urls:
query.addBindValue(url['url'])
query.addBindValue(url['creat_time'])
if query.execBatch():
print("Batch insert successful")
else:
print("Batch insert failed:", query.lastError().text())
只能使用pyside默认的数据库,因为其他模块都写好了。。用多了才知道默认数据库真是坑