MySQL之Set-Case1234567891011UPDATE t_nameSET a = case when type = '4' then null else a END,b = case when type = '4' then null else b END,WHERE id = 1 技术 / 数据库 MySQL, 面试2024-05-21