如何将URL参数字段保存到数据库中

import urllib.parse
import mysql.connector

# 解析URL参数
url = "http://example.com/?param1=value1&param2=value2"
parsed_params = urllib.parse.parse_qs(urllib.parse.urlparse(url).query)

# 连接数据库
cnx = mysql.connector.connect(user='username', password='password',
                              host='localhost', database='database_name')
cursor = cnx.cursor()

# 创建数据库表（如果不存在）
create_table_query = """
CREATE TABLE IF NOT EXISTS url_params (
    id INT AUTO_INCREMENT PRIMARY KEY,
    param_name VARCHAR(255),
    param_value VARCHAR(255)
)
"""
cursor.execute(create_table_query)

# 插入数据
insert_query = "INSERT INTO url_params (param_name, param_value) VALUES (%s, %s)"
for param_name, param_values in parsed_params.items():
    for param_value in param_values:
        cursor.execute(insert_query, (param_name, param_value))

# 处理重复数据（可选）
# ...

# 提交事务并关闭连接
cnx.commit()
cursor.close()
cnx.close()