使用mysql注销的C#更新代码

using MySql.Data.MySqlClient;

// 创建MySQL连接对象
string connectionString = "server=localhost;user=root;database=mydatabase;password=mypassword;";
MySqlConnection connection = new MySqlConnection(connectionString);

try
{
    // 打开数据库连接
    connection.Open();

    // 创建MySQL命令对象
    MySqlCommand command = connection.CreateCommand();

    // 编写SQL语句
    string sql = "UPDATE users SET is_logged_in = 0 WHERE username = 'example'";
    command.CommandText = sql;

    // 执行SQL语句
    int rowsAffected = command.ExecuteNonQuery();

    // 输出更新的行数
    Console.WriteLine("Rows affected: " + rowsAffected);
}
catch (Exception ex)
{
    Console.WriteLine("Error: " + ex.Message);
}
finally
{
    // 关闭数据库连接
    connection.Close();
}