如何使用Python在mysql中逐行插入txt数据

Question

我第一次学习python，有人能帮我如何读取每行的txt数据并每5秒将其输入mysql吗。提前谢谢

import time
import pymysql
connection = pymysql.connect(host="localhost",user="root",passwd="",database="testing" )
cursor = connection.cursor()
filepath = 'sometext.txt'
with open(filepath) as fp:
line = fp.readline()[:314]
cnt = 1
while line:`print("Line {}: {}".format(cnt, line.strip()))`insert1 = "INSERT INTO tes VALUES ('74' );"  

line = fp.readline()[:314]
cnt += 1
time.sleep(5)
cursor.execute(insert1)