2014年10月8日 星期三

excel-to-mysql multi lines data-import-by-words



Step 1 
make a file by Words: Mailing.


  1. mailing-select Recipients - use Existing List
  2. Insert Merge Field 
  3. Preview Results
  4. Auto Check for errors (complete the merge....)
  5. save to txt in utf-8



Update PRODUCT set description=’«Product_Description»’ where item_no=’«Item_No»’ and MARKET=1390288689150;



Step 2
use this file in notepad ++

Delete all space Line

Replace /r/n
to {spaceLine}


Step 3 
Read into mysql

source /erp/nethw3c.sql
 update PRODUCT SET DESCRIPTION=REPLACE(DESCRIPTION,'{nextLine}','\n');




沒有留言:

張貼留言