Step 1
make a file by Words: Mailing.
- mailing-select Recipients - use Existing List
- Insert Merge Field
- Preview Results
- Auto Check for errors (complete the merge....)
- 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');
沒有留言:
張貼留言