csv 转 sql

例如csv文件中有如下三条数据，每条数据有14列：

1,1002,整型数编辑框$每次变动数$1,100,NULL,NULL,NULL,0,0,NULL,0,0,工单ID,NULL
1,1002,整型数编辑框$每次变动数$1,100,NULL,NULL,NULL,0,0,NULL,0,8,工单ID,1
1,1003,文本编辑框,130,NULL,NULL,NULL,0,0,NULL,0,0,工单流水号,NULL

 

csv转sql的shell语句：

cat wf_column_info.csv|awk -F "," '{printf("insert into wf_column_info values(%s,%s,'\''%s'\'',%s,%s,%s,%s,%s,%s,%s,%s,%s,'\''
%s'\'',%s);\n",$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14)}' > wf_column_info.sql

转换后的sql：

insert into wf_column_info values(1,1002,'整型数编辑框$每次变动数$1',100,NULL,NULL,NULL,0,0,NULL,0,0,'工单ID',NULL);
insert into wf_column_info values(1,1002,'整型数编辑框$每次变动数$1',100,NULL,NULL,NULL,0,0,NULL,0,8,'工单ID',1);
insert into wf_column_info values(1,1003,'文本编辑框',130,NULL,NULL,NULL,0,0,NULL,0,0,'工单流水号',NULL);