如何在python中永久保存列表？

import pickle

my_list = [1, 2, 3, 4, 5]

# 保存列表到文件
with open('my_list.pkl', 'wb') as f:
    pickle.dump(my_list, f)

# 从文件中加载列表
with open('my_list.pkl', 'rb') as f:
    loaded_list = pickle.load(f)

print(loaded_list)  # 输出: [1, 2, 3, 4, 5]

import json

my_list = [1, 2, 3, 4, 5]

# 保存列表到文件
with open('my_list.json', 'w') as f:
    json.dump(my_list, f)

# 从文件中加载列表
with open('my_list.json', 'r') as f:
    loaded_list = json.load(f)

print(loaded_list)  # 输出: [1, 2, 3, 4, 5]

import mysql.connector

my_list = [1, 2, 3, 4, 5]

# 连接到MySQL数据库
conn = mysql.connector.connect(
    host='localhost',
    user='username',
    password='password',
    database='mydatabase'
)

# 创建表
cursor = conn.cursor()
cursor.execute("CREATE TABLE IF NOT EXISTS my_table (id INT AUTO_INCREMENT PRIMARY KEY, value INT)")

# 插入数据
for value in my_list:
    cursor.execute("INSERT INTO my_table (value) VALUES (%s)", (value,))

# 提交更改
conn.commit()

# 查询数据
cursor.execute("SELECT value FROM my_table")
loaded_list = [row[0] for row in cursor.fetchall()]

print(loaded_list)  # 输出: [1, 2, 3, 4, 5]

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