Python将带有“and‘随机混合的字符串插入到数据库

import random
import string
import mysql.connector

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

# 在字符串中插入"and"
def insert_and(random_string):
    index = random.randint(0, len(random_string) - 1)
    random_string = random_string[:index] + "and" + random_string[index:]
    return random_string

# 连接到MySQL数据库
def connect_to_database():
    conn = mysql.connector.connect(
        host="localhost",
        user="your_username",
        password="your_password",
        database="your_database"
    )
    return conn

# 插入数据到数据库
def insert_data(random_string):
    conn = connect_to_database()
    cursor = conn.cursor()
    sql = "INSERT INTO your_table (column_name) VALUES (%s)"
    values = (random_string,)
    cursor.execute(sql, values)
    conn.commit()
    conn.close()

# 生成随机字符串并插入到数据库
random_string = generate_random_string(10)
random_string_with_and = insert_and(random_string)
insert_data(random_string_with_and)