MySql - CASE WHEN之update 

UPDATE `goods` SET `type` = (
    CASE `name` WHEN 1 THEN 999  
    WHEN 2 THEN 1000  
    WHEN 3 THEN 1024  
    END)
posted @ 2021-11-30 15:05  vaen  阅读(139)  评论(0)    收藏  举报