So I want to make an update in MySQL where a value is updated if two conditions are true. So I have data in columns name and status. If the name and status match foo and d, then I want to change ...

Migrating from MySQL 5.7 to MySQL 8.0 or beyond will be a task that many developers and DBAs will have to support over the next few months. Start by planning ahead and understanding your options.