将列表中的随机字符串插入到表中

import random
import string
import pymysql

# 创建数据库连接
conn = pymysql.connect(host='localhost', user='username', password='password', database='database_name')

# 生成随机字符串
def generate_random_string(length):
    letters = string.ascii_letters + string.digits
    return ''.join(random.choice(letters) for _ in range(length))

# 插入数据
def insert_random_string(table_name, random_string):
    cursor = conn.cursor()
    sql = f"INSERT INTO {table_name} (random_string) VALUES ('{random_string}')"
    cursor.execute(sql)
    conn.commit()
    cursor.close()

# 调用函数插入随机字符串
random_string = generate_random_string(10)
insert_random_string('my_table', random_string)

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