txt文件内容导入mysql数据库中

import mysql.connector

# 1. 创建数据库连接
cnx = mysql.connector.connect(user='your_username', password='your_password', host='localhost', database='your_database')

# 2. 创建数据库游标
cursor = cnx.cursor()

# 3. 创建数据库表
create_table_query = '''
    CREATE TABLE IF NOT EXISTS txt_data (
        id INT AUTO_INCREMENT PRIMARY KEY,
        content TEXT
    )
'''
cursor.execute(create_table_query)

# 4. 准备数据
txt_file_path = 'path_to_your_txt_file.txt'
with open(txt_file_path, 'r') as file:
    txt_content = file.read()

# 5. 插入数据
insert_query = '''
    INSERT INTO txt_data (content) VALUES (%s)
'''
cursor.execute(insert_query, (txt_content,))

# 6. 提交事务并关闭连接
cnx.commit()
cursor.close()
cnx.close()