linux遍历文件每一行数据,shell:读取文件的每一行内容并输出

昨天写了一个脚本，只是做简单的表插入和表删除，写shell脚本的时候，死死的卡在shell读文件内容这块，所以写出来跟大家分享下。

num=`cat ptest.txt|wc -l`

echo $num

if [ $num -gt 0 ];then

while read feemobile

do

echo "insert into mms_subscribe_pause (packageid,businessid,packageidsmc,sendnum,recnum,booktime,subscribetime,subscribetype,subscribeip,mobiletypeid,suspendtime,suspendtyp

e,suspendip,suspendname,suspendreason,pidsmt,bidsmt,smcstatus,pidmianfei,bidmianfei,gateway,area,usertype,leagueid,status,Pcode,FeeCode,contenttype,isrelated) select packageid,b

usinessid,packageidsmc,sendnum,recnum,booktime,subscribetime,subscribetype,subscribeip,mobiletypeid,now(),'42','MISC_PAUSE','','',pidsmt,bidsmt,smcstatus,pidmianfei,bidmianfei,g

ateway,area,usertype,leagueid,status,Pcode,FeeCode,contenttype,isrelated from mms_subscribe where recnum='$feemobile';