- 论坛徽章:
- 20
|
凑个热闹,楼主在实现的需求一定要A,B两个文件吗?感觉你想复杂了(个人猜的),其实一个文件就可以了,
#awk -F'^' '{printf("INSERT INTO `t_o_org_job_job` VALUES (\047%d\047, \047%s\047, \0471\047, \0471\047);\n",++i,$1)}' A
INSERT INTO `t_o_org_job_job` VALUES ('1', '销售代表', '1', '1');
INSERT INTO `t_o_org_job_job` VALUES ('2', '客户代表', '1', '1');
INSERT INTO `t_o_org_job_job` VALUES ('3', '销售工程师', '1', '1');
INSERT INTO `t_o_org_job_job` VALUES ('4', '渠道/分销专员', '1', '1');
INSERT INTO `t_o_org_job_job` VALUES ('5', '业务拓展专员/助理', '1', '1');
INSERT INTO `t_o_org_job_job` VALUES ('6', '大客户销售代表', '1', '1');
如果需要去修改B的话:command > B |
|