Csharp MySQL如何在查询中插入变量

string connectionString = "your_connection_string";
string query = "SELECT * FROM your_table WHERE column_name = @variable";

using (MySqlConnection connection = new MySqlConnection(connectionString))
{
    using (MySqlCommand command = new MySqlCommand(query, connection))
    {
        command.Parameters.AddWithValue("@variable", your_variable);

        connection.Open();
        using (MySqlDataReader reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                // 处理查询结果
            }
        }
    }
}