MYSQL workbench error : You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

 SET SQL_SAFE_UPDATES = 0;

how to find the table name using column name in mysql

 SELECT DISTINCT TABLE_NAME 

    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('columnA','ColumnB')
        AND TABLE_SCHEMA='YourDatabase';

linq error At least one object must implement IComparable

 Well, you're trying to use SortedSet<>... which means you care about the ordering. But by the sounds of it your Player type doesn't implement IComparable<Player>. So what sort order would you expect to see?

Basically, you need to tell your Player code how to compare one player with another. Alternatively, you could implement IComparer<Player> somewhere else, and pass that comparison into the constructor of SortedSet<> to indicate what order you want the players in. For example, you could have:

public class PlayerNameComparer : IComparer<Player>
{
    public int Compare(Player x, Player y)
    {
        // TODO: Handle x or y being null, or them not having names
        return x.Name.CompareTo(y.Name);
    }
}

Then:

// Note name change to follow conventions, and also to remove the
// implication that it's a list when it's actually a set...
SortedSet<Player> players = new SortedSet<Player>(new PlayerNameComparer());

linq orderby collection property

 IQueryable<Parent> data = context.Parents.OrderBy(p=>p.Children.OrderBy(chi => chi.Name).FirstOrDefault());

How to execute sql queries in workbench mysql ?

 If you are from MS SQL background and first time working with MySql , you may be struggling for finding the shortcut key to execute the sql query in workbench. 

Here is the short cut to execute the SQL query in workbench MySql. 

Default key mapping

1. Execute (All or Selection) -> Ctrl + Shift + Enter.
2. Execute Current Statement -> Ctrl + Enter.