批量更新:
update package_android_today_download_count
set cnt = tmp.cnt
from (values (1,2),(2,3),(3,4),(4,5),(5,6)) as tmp (package_id, cnt)
where package_android_today_download_count.package_id = tmp.package_id
and create_date = current_date;
批量更新:
update package_android_today_download_count
set cnt = tmp.cnt
from (values (1,2),(2,3),(3,4),(4,5),(5,6)) as tmp (package_id, cnt)
where package_android_today_download_count.package_id = tmp.package_id
and create_date = current_date;