先下载pymysql (pip install pymysql)再导入(import pymysql)
然后:
举例
def update_hotsearch():
"""
将疫情热搜插入数据库
"""
cursor=None
conn=None
try:
context=get_baidu_hot
print(f"{time.asctime()}开始更新热搜数据")
conn,cursor=get_conn()
sql="insert into hotsearch(dt,content) values(%s,%s)"
ts=time.strftime("%Y-%m-%d")
for i in context:
cursor.execute(sql,(ts,i)) #插入数据
conn.commit() #提交事务保存数据
print(f"{time.asctime()}更新热搜数据完毕")
except:
traceback.print_exc()#打印异常结果
finally:
close_conn(conn,cursor)
出现报错:python连接mysql AttributeError: module ‘pymysql’ has no attribute ‘connect’ :文件名与pymysql重名