替换拼接出现异常 ，求大神

moperyblue

1. more sqlPrefix

复制代码

UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN '"language"=>"CHINESE"'::hstore ELSE attrs || '"language"=>"CHINESE"'::hstore END WHERE hotel_seq=

1. sed -r '1{x;s/.*/cat sqlPrefix/e;x};G;s/(.*)\n(.*)/\2\1/'
   
2. #或
   
3. sed 'r sqlPrefix'|sed -r 'N;s/(.*)\n(.*)/\2\1/'

复制代码

杰瑞26

root@localhost:~# str="UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN '"language"=>"CHINESE"'::hstore ELSE attrs || '"language"=>"CHINESE"'::hstore END WHERE hotel_seq="
root@localhost:~# sed -r "s#(.*)#${str}\\1#g" file

1. UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN 'language=>CHINESE'::hstore ELSE attrs || 'language=>CHINESE'::hstore END WHERE hotel_seq="rizhao_5894";
   
2. UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN 'language=>CHINESE'::hstore ELSE attrs || 'language=>CHINESE'::hstore END WHERE hotel_seq="shanghai_city_17514";
   
3. UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN 'language=>CHINESE'::hstore ELSE attrs || 'language=>CHINESE'::hstore END WHERE hotel_seq="linfen_4028";
   
4. UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN 'language=>CHINESE'::hstore ELSE attrs || 'language=>CHINESE'::hstore END WHERE hotel_seq="heyuan_4577";
   
5. UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN 'language=>CHINESE'::hstore ELSE attrs || 'language=>CHINESE'::hstore END WHERE hotel_seq="jinzhong_3205";
   
6. UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN 'language=>CHINESE'::hstore ELSE attrs || 'language=>CHINESE'::hstore END WHERE hotel_seq="sanya_10514";
   
7. UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN 'language=>CHINESE'::hstore ELSE attrs || 'language=>CHINESE'::hstore END WHERE hotel_seq="wuhu_3082";
   
8. UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN 'language=>CHINESE'::hstore ELSE attrs || 'language=>CHINESE'::hstore END WHERE hotel_seq="fushun_2402";
   
9. UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN 'language=>CHINESE'::hstore ELSE attrs || 'language=>CHINESE'::hstore END WHERE hotel_seq="baoding_4349";
   
10. UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN 'language=>CHINESE'::hstore ELSE attrs || 'language=>CHINESE'::hstore END WHERE hotel_seq="puyang_2319";
    

复制代码