记录:sql从指定值列表随机拿值update表的某个字段写法
update dgc_dishonesty_result
set AREA = (case floor(random()*9)
when 0 then '莞城街道'
when 1 then '东城街道'
when 2 then '石龙镇'
when 3 then '横沥镇'
when 4 then '厚街镇'
when 5 then '寮步镇'
when 6 then '南城街道'
when 7 then '石排镇'
when 8 then '茶山镇'
when 9 then '东坑镇'
end);