awk 利用
cat out.txt |sed 1d |awk -F \\t '{print "insert into kw (id, kw, url, s_type, insert_time) values(0," $3 ", \"http:\/\/my.my.com" $2 "\", \"" $1 "\", CURRENT_TIMESTAMP());"}'
by sato025
| 2008-09-11 18:48