内容摘要:复制MySQL>SELECTCASE1WHEN1THENone ->WHEN2THENtwoELSEmoreEND; ->one
实际复制MySQL> SELECT CASE 1 WHEN 1 THEN one -> WHEN 2 THEN two ELSE more END; -> one MySQL> SELECT CASE WHEN 1>0 THEN true ELSE false END; -> true MySQL> SELECT CASE BINARY B -> WHEN a THEN 1 WHEN b THEN 2 END; -> NULL 1.2.3.4.5.6.7.8.