数据上传云服务器数据库

import mysql.connector
from mysql.connector import Error

def upload_data_to_cloud_db(host, database, user, password, data):
    try:
        connection = mysql.connector.connect(host=host,
                                             database=database,
                                             user=user,
                                             password=password)
        if connection.is_connected():
            cursor = connection.cursor()
            insert_query = "INSERT INTO your_table (column1, column2) VALUES (%s, %s)"
            cursor.execute(insert_query, data)
            connection.commit()
            print("Data uploaded successfully")
    except Error as e:
        print(f"Error while connecting to MySQL: {e}")
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()
            print("MySQL connection is closed")

# 示例调用
upload_data_to_cloud_db('your_cloud_host', 'your_database', 'your_user', 'your_password', ('value1', 'value2'))