importing the txt files from a directory into a mysql database

db_import_textfiles.py

import os
import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  password="",
  database="default"
)
mycursor = mydb.cursor()
sql = "INSERT INTO table (page, filename) VALUES (%s, %s )"
directory = r'C:/directory'
for filename in os.listdir(directory):
    if filename.endswith(".txt"):
    	page = open(os.path.join(directory, filename), "r")
    	val = ( page.read(), filename)
    	mycursor.execute(sql,val)
    	mydb.commit()
    else:
        continue