如何将数据插入blob C#/mysql/uwp

CREATE TABLE my_table (
    id INT PRIMARY KEY AUTO_INCREMENT,
    data BLOB
);

using MySql.Data.MySqlClient;

string connectionString = "server=your_server;user=your_username;database=your_database;password=your_password";
string query = "INSERT INTO my_table (data) VALUES (@data)";

using (MySqlConnection connection = new MySqlConnection(connectionString))
{
    connection.Open();

    using (MySqlCommand command = new MySqlCommand(query, connection))
    {
        // 将数据转换为字节数组
        byte[] dataBytes = Encoding.UTF8.GetBytes("Your data");

        // 添加参数并设置值
        command.Parameters.AddWithValue("@data", dataBytes);

        // 执行插入操作
        command.ExecuteNonQuery();
    }
}