做數(shù)據(jù)庫重構(gòu)之后做數(shù)據(jù)導(dǎo)入需要將字符串轉(zhuǎn)換為int類型，轉(zhuǎn)換的情況太多于是采用了update和case語句結(jié)合，果然省了很多的SQL
UPDATE testSET avg_discount_area = ( CASE WHEN avg_discount_area ='9.5折以上' THEN 0WHEN avg_discount_area ='（8.0~8.5）折' THEN 1WHEN avg_discount_area ='（6.5~8.0）折' THEN 2WHEN avg_discount_area ='（4.0~6.5）折' THEN 3WHEN avg_discount_area='（2.5~4.0）折' THEN 4WHEN avg_discount_area='（1.0~2.5折）' THEN 5WHEN avg_discount_area = '1折以下' THEN 6WHEN avg_discount_area = '無數(shù)據(jù)' THEN 7END);新聞熱點
疑難解答
