麻煩前輩幫寫個shell，功能是讀取linux下某個目錄下的某個特定文件，將某些字符串load到mysql的指定表中

#!/bin/sh?-e

LOGFILE=/root/access.log

BAKDIR=/root/ng_log_bak

TMPSQL=/tmp/altmp.sql

if?[?-f?${LOGFILE}?];?then

cat?${LOGFILE}?|?gawk?-F'?'?'{?print?"insert?into?table_name(col1,col2)?values(`"substr($4,2)"`,`"gensub(".*?act=","","g",$13)"`);";?}'?>?${TMPSQL}

mysql?--user=user?--password=passwd?db_name?<?${TMPSQL}

rm?${TMPSQL}

mv?${LOGFILE}?${BAKDIR}/access.log.$(date?+%Y%m%d%H%m)