如何创建一个可以随机填充数据集中的数据的表？

import random
import string
import mysql.connector

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

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

# 创建表
create_table_query = """
CREATE TABLE random_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    number INT,
    text VARCHAR(255)
)
"""
cursor.execute(create_table_query)

# 随机填充数据
for _ in range(10):
    number = random.randint(1, 100)
    text = ''.join(random.choices(string.ascii_letters, k=10))
    insert_query = f"INSERT INTO random_data (number, text) VALUES ({number}, '{text}')"
    cursor.execute(insert_query)

# 提交事务
conn.commit()

# 查询数据
select_query = "SELECT * FROM random_data"
cursor.execute(select_query)
result = cursor.fetchall()
for row in result:
    print(row)

# 关闭连接
cursor.close()
conn.close()