Excel批量写sql

比眉伴天荒 2022-04-11 12:51 306阅读 0赞

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTQwMjA1_size_16_color_FFFFFF_t_70][]

修改另一张表的相同字段数据,写成单条update

="UPDATE erp_order SET merchants_sales_man ='"&B1&"' WHERE merchants_sales_man='"&A1&"';"

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTQwMjA1_size_16_color_FFFFFF_t_70 1][]

UPDATE erp_order SET merchants_sales_man ='李敬涛' WHERE merchants_sales_man='103';
    UPDATE erp_order SET merchants_sales_man ='匡琪' WHERE merchants_sales_man='156d1afbdcde4dafb6f7415012907cf2';
    UPDATE erp_order SET merchants_sales_man ='谈婷婷' WHERE merchants_sales_man='26';
    UPDATE erp_order SET merchants_sales_man ='汉口店' WHERE merchants_sales_man='28';
    UPDATE erp_order SET merchants_sales_man ='孟耀博' WHERE merchants_sales_man='283e9ea97b0e4f7a8cf87d6e9f3079b8';
    UPDATE erp_order SET merchants_sales_man ='邓婷婷' WHERE merchants_sales_man='296ea1ab2a884ba3a5fde4fb7a6ba0f9';
    UPDATE erp_order SET merchants_sales_man ='洪学宇' WHERE merchants_sales_man='36';
    UPDATE erp_order SET merchants_sales_man ='肖蒙' WHERE merchants_sales_man='36376a22e8944efca0fffb362f4547d8';
    UPDATE erp_order SET merchants_sales_man ='周文怡' WHERE merchants_sales_man='380baf16c06e4a558adf87814f540461';
    UPDATE erp_order SET merchants_sales_man ='张雨娟' WHERE merchants_sales_man='40';
    UPDATE erp_order SET merchants_sales_man ='邓好' WHERE merchants_sales_man='48';
    UPDATE erp_order SET merchants_sales_man ='王捷' WHERE merchants_sales_man='50';
    UPDATE erp_order SET merchants_sales_man ='黄忠刚' WHERE merchants_sales_man='52';
    UPDATE erp_order SET merchants_sales_man ='魏航' WHERE merchants_sales_man='58';
    UPDATE erp_order SET merchants_sales_man ='自提' WHERE merchants_sales_man='61';
    UPDATE erp_order SET merchants_sales_man ='宋青飞' WHERE merchants_sales_man='69';
    UPDATE erp_order SET merchants_sales_man ='陈星' WHERE merchants_sales_man='73d554597cb44996a150e0e38af1393d';
    UPDATE erp_order SET merchants_sales_man ='李亚' WHERE merchants_sales_man='7cf332402d224821abf8b5c8b5b6c492';
    UPDATE erp_order SET merchants_sales_man ='杨超' WHERE merchants_sales_man='97';
    UPDATE erp_order SET merchants_sales_man ='尚坤鹏' WHERE merchants_sales_man='ada785b9a69740ccac3a854b084c5e1f';
    UPDATE erp_order SET merchants_sales_man ='罗伟宾' WHERE merchants_sales_man='bda56de5dc0c488095d1fcdc49535d3e';
    UPDATE erp_order SET merchants_sales_man ='广州门店_进店' WHERE merchants_sales_man='c6157d1d2dba4d1d9101a791fbd98ae2';
    UPDATE erp_order SET merchants_sales_man ='方亮' WHERE merchants_sales_man='e61c379128ce483da70c214790b49806';

="INSERT INTO `user_advance` (`user_id`,`money`,`message`,`mtime`,`memo`,`import_money`, `member_advance`,`create_name`) VALUES ('"&A2&"','"&H2&"','pop预存款充值','"&TEXT(L2,"yyyy-mm-dd HH:mm:ss")&"','数据修复','"&H2&"','"&D2&"','admin');"

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTQwMjA1_size_16_color_FFFFFF_t_70]: /images/20220411/9f5889c61c7742e6a6e289c77c0e0e63.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5OTQwMjA1_size_16_color_FFFFFF_t_70 1]: /images/20220411/85305ff177614522abbf765dc97cf6b3.png