从文件里导入数据到mysql数据库

import os


def findAllFile(base):
    for root, ds, fs in os.walk(base):
        for f in fs:
            yield f
def main():
    base = '.'
    for i in findAllFile(base):
        print(i)

def getcontent(file):
        with open(file,'r') as f:
            list = []
            for line in f.readlines():
                list.append(line)
            f.close()
            print(list)

import pymysql

# 连接到数据库
con = pymysql.connect(host="你的主机IP",
                      user='用户名',
                      password="123456",
                      port=3306,
                      database='xiaohua',
                      charset='utf8'
                     )
# 创建游标
cur = con.cursor()
print(cur)
# 执行对应的sql语句
sql = "insert into students values('0001','title','content');"
cur.execute(sql)
con.commit()
cur.close() # 关闭游标
con.close() # 关闭数据库连接