mysql - Update Case When, with multiple conditions - Stack Overflow

2014年11月14日 - If you do not explicitly add an else clause to a case expression, it implicitly acts as though you've added else null to it. So, your update statement is ...

stackoverflow.com