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 ...

For a missing value, MySQL sets the column to the implicit default for its data type. Implicit defaults were described in Section 3.2.3, “Specifying Column Default Values.†...