1-新增一列 ,在列中填入公司:=CONCATENATE("insert into users (name,sex,age) values ('",B1,"','",C1,"','",D1,"');")
公式示例
=CONCATENATE("insert into users (name,sex,age) values ('",B1,"','",C1,"','",D1,"');")
",B1," 表示取一列数据
'",B1,"' 取出数据后加上字符串符号
2-从公式列往下拖,批次生成sql语句。
SELECT * FROM `bankcardinfo` bank
where BANKACCO in(CONCATENATE("A1"));
CONCATENATE("insert into base_express (code,code_desc) values ('",B1,"','",C1"');")
=CONCATENATE("insert into `dict_lis_item` (`id`, `p_item_code`, `p_item_name`, `item_code`,`item_spec`, `unit`, `fk_tenant_id`, `create_time`, `create_user_id`, `update_time`, `update_user_id`)
values (getPrimaryKeyByClassName('DictLisItem'),'",C2,"','",D2,"','",G2,"','",H2,"','",J2,"',1018701,NOW(),1,NOW(),1);")