- 论坛徽章:
- 22
|
本帖最后由 聆雨淋夜 于 2015-08-29 20:51 编辑
awk '{gsub(/,[^)]+/,"",$0);sub(/selling_price=[^;]+/,"product_type= 1",$0)}1' file
insert into sbg_glasses_price_24(color_code_id) values(4717) ON DUPLICATE KEY UPDATE product_type= 1;
insert into sbg_glasses_price_24(color_code_id) values(4718) ON DUPLICATE KEY UPDATE product_type= 1;
sed -r 's/,[^)]+//;s/selling_price=[^;]+/product_type= 1/' file
insert into sbg_glasses_price_24(color_code_id) values(4717,200.95) ON DUPLICATE KEY UPDATE product_type= 1;
insert into sbg_glasses_price_24(color_code_id) values(4718,200.15) ON DUPLICATE KEY UPDATE product_type= 1;
都差不多,就是替换 |
|