本地txt导入mysql数据库中

CREATE TABLE IF NOT EXISTS `data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

import MySQLdb

# 连接MySQL数据库
db = MySQLdb.connect(host="localhost", user="root", passwd="your_password", db="your_database_name", charset="utf8")

# 创建游标对象
cursor = db.cursor()

# 打开txt文件
with open('data.txt', 'r') as file:
    # 逐行读取txt文件内容
    for line in file:
        # 插入数据到数据库表中
        cursor.execute("INSERT INTO `data` (`content`) VALUES (%s)", (line.strip(),))

# 提交事务并关闭连接
db.commit()
db.close()