EXCLE常用

EXCLE转sql

在当前行的最后新增一列，输入下面函数(其中表字段因人而异)
将鼠标悬停在当前单元格的右下角，当右下角变成加号时，双击即可
A2和D2是中文所以加单引号

=CONCATENATE("insert into rh_ask (title,type,cid,daan,yes_daan) values ('",A2,"',",B2,",",C2,",'",D2,"',",E2,");")