txt文件内容导入mysql数据库

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

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='your_username', password='your_password', db='your_database')
cursor = conn.cursor()

# 读取txt文件内容
with open('path_to_your_txt_file.txt', 'r') as file:
    content = file.read()

# 执行插入操作
sql = "INSERT INTO my_table (content) VALUES (%s)"
cursor.execute(sql, (content,))
conn.commit()

# 关闭数据库连接
cursor.close()
conn.close()