The update case needs to be updated according to the condition column in MySQL update

Whether the following two statements can be combined into one:

UpdateT9SetId=1 whereB>'2015-10-12'; UpdateT9SetId=1E='2015-01-01'  whereB='2015-10-12';

Now that I've come to write a blog, the answer must be yes,

Here's how to combine the two update statements above into one:

 update  T9 set  id=  1 , E=  ( Span style= "color: #ff00ff;" >case  when  b=   '  2015-10-12   '   

That

When b equals '2015-10-12' , the E value is set to '2015-01-01' when B is greater than '  2015-10-12' , the E value remains the same.

This is a small trick, a friend who needs to take it though.

The update case needs to be updated according to the condition column in MySQL update