mysql -u xxx -p -h xxx table -e <\/p>\n\n\n\n
“set names gbk; select f_id,f_app_style_url,f_brand_name,f_category,f_category1,f_category2,f_category3,f_image_path,f_introduction,f_is_canvat,f_jd_price,f_market_price,f_naked_price,f_name,f_no_reason_to_return,f_p_name,f_page_num,f_param,f_pc_style_url,f_price,f_product_area,f_product_name,f_profit,f_profit_margin,f_sale_state,f_sale_unit,CONCAT(‘\\”,f_sku) as f_sku,f_sku_image_paths,CONCAT(‘\\”,f_spu_id) as f_spu_id,f_state,f_tax,f_tax_price,f_thwa,CONCAT(‘\\”,f_upc) as f_upc,CONCAT(‘\\”,f_upc69) as f_upc69,f_weight,f_category1name,f_category2name,f_category3name,f_category_name,f_sku_attribute_flag,f_sku_attribute_num,f_sku_pro1link_sku_ids,f_sku_pro1name,f_sku_pro1ohter_value,f_sku_pro1value,f_sku_pro2link_sku_ids,f_sku_pro2name,f_sku_pro2ohter_value,f_sku_pro2value,f_sku_pro3link_sku_ids,f_sku_pro3name,f_sku_pro3ohter_value,f_sku_pro3value,f_sku_pro4link_sku_ids,f_sku_pro4name,f_sku_pro4ohter_value,f_sku_pro4value,f_sku_pro5link_sku_ids,f_sku_pro5name,f_sku_pro5ohter_value,f_sku_pro5value,f_syn_product_sku_id,f_capacity,f_contract_sku_ext,f_isjdlogistics,f_is_self,f_nappintroduction,f_nintroduction,f_param_detail_json,f_param_json,f_wserve,f_wxintroduction,f_sku_pro1img,f_sku_pro2img,f_sku_pro3img,f_sku_pro4img,f_sku_pro5img,REPLACE(REPLACE(f_wareqd,CHAR(10),’ ‘),CHAR(13),’ ‘) as f_wareqd from t_vop_product_brief limit 100″ <\/p>\n\n\n\n
|sed -e “s\/\\t\/,\/g” -e “s\/NULL\/ \/g” -e “s\/\\n\/\\r\\n\/g” > <\/p>\n\n\n\n
\/mnt\/mntnas\/dbbak\/t_vop_product_brief_xxx.csv<\/p>\n\n\n\n
\u4e0a\u9762\u547d\u4ee4\u53ef\u4ee5\u5206\u4e3a4\u4e2a\u90e8\u5206
\u7b2c\u4e00\u90e8\u5206\u662fmysql\u547d\u4ee4\uff1b
\u7b2c\u4e8c\u90e8\u5206\u662f\u6307\u5b9a\u5bfc\u51fa\u7684\u5217\uff0c\u8fd9\u91cc\u53ef\u4ee5\u7528*\uff0c\u4f46\u662f*\u5c31\u4e0d\u597d\u5355\u72ec\u5904\u7406\u6bcf\u4e2a\u5217\uff0c\u6709\u7684\u5217\u5bfc\u51fa\u540e\u4f1a\u79d1\u5b66\u8ba1\u6570\uff0c\u6709\u7684\u4f1a\u6362\u884c\uff0c\u9700\u8981\u5904\u7406\uff1b
\u7b2c\u4e09\u90e8\u5206\u662f\u5904\u7406\u6362\u884c\u7b49\u5b57\u7b26\uff1b
\u7b2c\u56db\u90e8\u5206\u5c31\u662f\u5bfc\u51fa\u4f4d\u7f6e\uff1b<\/pre>\n\n\n\n\u8fd8\u53ef\u4ee5\u7528\u4e0b\u9762\u7684\u547d\u4ee4\u5bfc\u51fa\uff0c\u4f46\u662f\u8fd9\u6837\u5b50\u5bfc\u51fa\u6ca1\u6709\u8868\u5934<\/p>\n\n\n\n
SELECT * FROM t_vop_product_brief limit 100
INTO OUTFILE ‘\/Users\/zeroheart\/Desktop\/xxxx.csv’
FIELDS TERMINATED BY ‘,’
OPTIONALLY ENCLOSED BY ‘”‘
LINES TERMINATED BY ‘\\n’;<\/p>\n\n\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"
mysql -u xxx -p -h xxx table -e “set names gbk; s […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[61,62],"_links":{"self":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1187"}],"collection":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1187"}],"version-history":[{"count":3,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1187\/revisions"}],"predecessor-version":[{"id":1190,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1187\/revisions\/1190"}],"wp:attachment":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}