def insert_data(dbName,data_dict):
try:
data_values = "(" + "%s," * (len(data_dict)) + ")"
data_values = data_values.replace(',)', ')')
dbField = data_dict.keys()
dataTuple = tuple(data_dict.values())
dbField = str(tuple(dbField)).replace("'",'')
conn = pymysql.connect(host="IP地址", user="用户名", passwd="密码", db="数据库名", charset="utf8")
cursor = conn.cursor()
sql = """ insert into %s %s values %s """ % (dbName,dbField,data_values)
params = dataTuple
cursor.execute(sql, params)
conn.commit()
cursor.close()
print ("===== 插入成功 =====")
return 1
except Exception as e:
print("******** 插入失败 ********")
print(e)
return 0
# 数据库的名称
dbName = "newsURL"
# 插入的数据
data_dict = {
"news_url": urlList[],
"acreate_time": now,
"last_edit_time": now
}
result11 = insert_data(dbName, data_dict)
print(result11)
python连接mysql并插入数据(网摘)
最新推荐文章于 2024-01-31 20:58:49 发布