excel 生成sql语句
程序员文章站
2022-05-25 17:02:14
...
假设Excel中有N条数据结构如下
A | B | C | D | E | F | G | H |
---|---|---|---|---|---|---|---|
customer_code | customer_name | dept_code | dept_name | standard_code | status | active | |
1 | 客户名称1 | D1 | 部门名称1 | DP1 | Y | Y | |
2 | 客户名称2 | D2 | 部门名称2 | DP2 | Y | Y | |
N | 客户名称N | DN | 部门名称N | DPN | Y | Y |
一、第一条数据 在H1 填写以下参数
=CONCATENATE("insert into cmcdb.t_cmc_try_bury (customer_code,customer_name,dept_code,dept_name,standard_code,status,active)
values ('",A2,"','",B2,"','",C2,"','",D2,"','",E2,"','",F2,"','",G2,"'),")
效果:
二、第2~(N-1) 条数据
在H2~H(N-1)填写
=CONCATENATE("('",A3,"','",B3,"','",C3,"','",D3,"','",E3,"','",F3,"','",G3,"'),")
效果:
三、最后一条数据
在Hn中填写:
=CONCATENATE("('",An,"','",Bn,"','",Cn,"','",Dn,"','",En,"','",Fn,"','",n,"');")
效果: