#coding=utf-8

import MySQLdb

def db_execute(sql):
    dbs = MySQLdb.connect(host='你的ip', user='帐号', passwd='密码', db='数据库', port=3306)
    cursor = dbs.cursor()
    cursor.execute(sql)
    cursor.close()


def read_file(file_path):
    sql_lines = []
    with open(file_path, 'r') as file:
        for line in file.readlines():
            sql = 'insert table(field) values({0});'.format(line)
            sql_lines.append(sql)

    return '\r\n'.join(sql_lines)

sql_lines = read_file('a.txt')
db_execute(sql_lines)    

Hello! A little suggestion, if you have a ready-made text file, it is recommended to use the
"Load Data Infile" command in mysql, which is more efficient!
Related links: (1) http://blog.sina.com.cn/s/blog_97688f8e0101hgfx.html

     （2）http://blog.csdn.net/vbloveshllm/article/details/42965317

One of the pictures is the program import mysqldb, there is no problem, it has been tested
The second picture is the text file that needs to be imported, of course the IP address
The third picture is the error message, in fact, I am in the program One of the sentences prints out print sql_lines. There is no problem inserting one of the sentences into mysql, but I don’t know where it appears.

Please take a look during your busy schedule