notepad++ text substitution to solve the data manipulation of Excel batch modification database

^ \ (' Start
\ t ', ' tab
$ ' \) End of line

After copying it, use the text substitution feature to convert to SQL and add to the staging table. Then multiple tables are associated with the modification.

SELECT COUNT (*) from OrderNo; # 933 Lines
# single
UPDATE account_log t1,orderno T2 SET t1. ' Flag ' =1 WHERE t1. ' Order_no ' =t2. ' Order_no ' and t1. ' Income_type ' =4 and t1. ' Order_n o ' = ' 557083624061 ';
# A total of 932 rows affected
UPDATE account_log t1,orderno T2 SET t1. ' Flag ' =1 WHERE t1. ' Order_no ' =t2. ' Order_no ' and t1. ' Income_type ' = 4;

160308.txt

notepad++ text substitution to solve the data manipulation of Excel batch modification database