Python读取数据库写入TXT中（一条数据写入一个TXT文本）

import os import pymysql conn = pymysql.connect( host='localhost', user='root', password='123456', db='news', charset='utf8', # autocommit=True, # 如果插入数据，， 是否自动提交? 和conn.commit()功能一致。 ) def selecttable(): # **************************数据库查询***************************** cur = conn.cursor() sql3 = "select * from zh_new limit 100;" #新闻的条数 result = cur.execute(sql3) # 默认不返回查询结果集， 返回数据记录数。 print(result) for i in range(100): path_list = ['news', str(i) + '.txt'] x=cur.fetchone() print(x[0]) #新闻标题 print(x[1]) #新闻内容 head = '' for path in path_list: head = os.path.join(head, path) print(head) with open(head,"w",encoding='UTF-8') as file: #”w"代表着每次运行都覆盖内容 file.write(x[0] + " 内容：" + x[1]+"\n") # 4. 关闭游标 cur.close() # 5. 关闭连接 conn.close() if __name__=='__main__': selecttable()