sale_daily表，quyu字段当时为空，需求：按louceng字段复制过来，怎么能一把订正。
select *,case when length(quyu)=0 then louceng else quyu end as name from sale_daily
select case when quyu is null then loceng esle quyu end quyu from sale_daily
1min目标场景问卷
立即参与
