把文本内容传入mysql数据库

import pymysql
import os
from datetime import datetime
conn = pymysql.connect(host='106.14.120.238',
                           port=13306,
                           user="raysedu",#需要改自己的mysql用户名
                           passwd='wsHdUeZObP',#需要改自己的mysql密码
                           db="raysedu",#需要改自己的数据库
                           charset='utf8',
                           use_unicode=True)
cursor = conn.cursor()
# conn = pymysql.connect(host='localhost',
#                            port=3306,
#                            user="root",#需要改自己的mysql用户名
#                            passwd='root',#需要改自己的mysql密码
#                            db="jj",#需要改自己的数据库
#                            charset='utf8',
#                            use_unicode=True)
# cursor = conn.cursor()
sql = "INSERT INTO zuowen (grade,article_name,word_number,content,source,create_time,type) VALUES (%s,%s,%s,%s,%s,%s,%s)"#需要改自己的数据表
a=['一年级','二年级','三年级','四年级','五年级','六年级']
b=['100字','150字','200字','250字','300字']
k=[]
for i in a:
    for j in b:
        try:
            files= os.listdir("日记"+'/'+i+'/'+j)
            for file in files:
                position = "日记"+'/'+i + '/' + j + '/' + file
                with open(position,'r',encoding="utf-8") as f:
                    d=[]
                    c=f.read()
                    for q in c.split("\n"):
                        time = datetime.now().strftime("%Y-%m-%d %H-%M-%S")
                        d.append(q)
                    k.append([i,d[0],j,d[1],1,time,1])
        except:
            continue
for n in k:
    cursor.execute(sql, n)
    print("成功！")
conn.commit()
cursor.close()
conn.close()