dmp数据能导入mysql吗

import mysql.connector

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 创建表（如果表不存在）
cursor.execute("""
CREATE TABLE IF NOT EXISTS dmp_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id VARCHAR(255),
    action VARCHAR(255),
    timestamp DATETIME
)
""")

# 假设dmp_data_list是从DMP平台获取的数据列表
dmp_data_list = [
    {"user_id": "123", "action": "click", "timestamp": "2023-04-01 12:00:00"},
    # ... 其他数据
]

# 插入数据到MySQL表中
for data in dmp_data_list:
    cursor.execute("""
    INSERT INTO dmp_data (user_id, action, timestamp)
    VALUES (%s, %s, %s)
    """, (data["user_id"], data["action"], data["timestamp"]))

# 提交更改并关闭连接
db.commit()
cursor.close()
db.close()