- 论坛徽章:
- 0
|
这个awk脚本为什么不能执行呢?
BEGIN{
}
{
printf("insert into card_log select cardno,callingnumber,callednumber,char
geclass,batch,0,stoptime,0 from rec_200_200603 where cardno=%s and stoptime in (
select min(stoptime) from rec_200_200603 where cardno=%s);\n",$1,$1)
}
->
printf("insert into card_log select cardno,callingnumber,callednumber,char
geclass,batch,0,stoptime,0 from rec_200_200603 where cardno=%s and stoptime in %s
select min%sstoptime%sfrom rec_200_200603 where cardno=%s%s;\n",$1, "(", "(", ")", $1, ")"); |
|