mysql批量更新
update tb_pluss_all_bill set totalReceivedFee = CASE billCode WHEN 2019072712012354237 THEN 670 WHEN 2019072705293864729 THEN 0 WHEN 2019072802254623048 THEN 0 END where billCode in ('2019072712012354237','2019072705293864729','2019072802254623048')
update tb_pluss_all_bill set totalReceivedFee = CASE billCode WHEN 2019072506144 THEN 400 WHEN 2019072693818 THEN 0 WHEN 2019072615233 THEN 0 END where billCode in ('2019072506144','2019072693818','2019072615233')
这两个sql的批量更新语句上面的一个不生效,在when的条件上面加上引号就行了,是什么问题呀