- 论坛徽章:
- 1
|
本帖最后由 这个冬天不冷 于 2013-12-23 17:26 编辑
回复 4# joepayne
确实写死了。最后一个;直接在awk -vFS="[(),]" '{printf("%s(%s,%s,%s,%s",$1,$2,$3,$5,$6) ;print ");"}' 最后加一个;就ok了
[root@everIover ~]# awk -vFS="[(),]" -vM=3 '{printf("%s(",$1);for(i=2;i<=6;i++){if(i==M)continue;printf("%s%s",f,$i);f=","}print ");";f=""}' ii- [root@everIover ~]# awk -vFS="[(),]" -vM=3 '{printf("%s(",$1);for(i=2;i<=6;i++){if(i==M)continue;printf("%s%s",f,$i);f=","}print ");";f=""}' ii
- insert into t values(1,78,'greger2343','grtg');
- insert into t values(2,44,'jty','grtg');
- insert into t values(3,65,'66k','ghre');
- insert into t values(4,68,'yj','g5');
- insert into t values(5,98,'67','54h');
- [root@everIover ~]# cat ii
- insert into t values(1,'abc',78,'greger2343','grtg');
- insert into t values(2,'dgre',44,'jty','grtg');
- insert into t values(3,'grhg',65,'66k','ghre');
- insert into t values(4,'muy',68,'yj','g5');
- insert into t values(5,'54yn',98,'67','54h');
- [root@everIover ~]#
复制代码 |
|