使用python在数据库中存储动态列表/数组

import MySQLdb

# 连接数据库
db = MySQLdb.connect(host="localhost", user="username", passwd="password", db="database_name")

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

# 创建数据表
create_table_query = "CREATE TABLE IF NOT EXISTS dynamic_list (id INT AUTO_INCREMENT PRIMARY KEY, element VARCHAR(255))"
cursor.execute(create_table_query)

# 动态列表/数组
my_list = ["element1", "element2", "element3"]

# 插入数据
for element in my_list:
    insert_query = "INSERT INTO dynamic_list (element) VALUES ('{}')".format(element)
    cursor.execute(insert_query)

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

# 更新数据
update_query = "UPDATE dynamic_list SET element = 'new_element' WHERE id = 1"
cursor.execute(update_query)

# 删除数据
delete_query = "DELETE FROM dynamic_list WHERE id = 2"
cursor.execute(delete_query)

# 提交更改
db.commit()

# 关闭游标和数据库连接
cursor.close()
db.close()