C#在select查询中使用函数来解密表数据

using System;
using MySql.Data.MySqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "server=localhost;user=root;database=mydb;password=mypassword";
        string query = "SELECT AES_DECRYPT(column_name, 'encryption_key') AS decrypted_data FROM table_name";

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

            MySqlCommand command = new MySqlCommand(query, connection);
            MySqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                string decryptedData = reader.GetString("decrypted_data");
                Console.WriteLine(decryptedData);
            }

            reader.Close();
        }
    }
}