linux 脚本练手

iteye_16377

于 2012-02-22 17:44:10 发布

阅读量240

点赞数

CC 4.0 BY-SA版权

文章标签： awk 操作系统数据库

本文链接：https://blog.youkuaiyun.com/iteye_16377/article/details/82280936

通过输入用户id 查询出正式机用户密码

#!/bin/sh
function findPassword(){
   read -p "please input memberId:"  memberId
   echo "$memberId" | awk '{printf "select pwd_2 from core_user.MemberLoginInfo_%02d where memberId=%d;",$1%100,$1}' | mysql -uuserName -ppassword -h10.10.10.01
}
findPassword

插入日志到数据库

#!/bin/sh
function insertSql(){
     cat /www/logs/$1 | awk -F"|" '{print "insert into user_login_third (snsType,snsAccount,snsUserName,ip,loginTime) values ("$2",\047"$5"\047,"$4",\047"$3"\047,\047"$6"\047);"}' |mysql -uuserName -ppassword -h10.10.10.01
datebase_Msg
}

function passParam(){

echo "" | awk '{for(i=1;i<30;i++){printf("%02d\n",i);}}'
}

function main() {
  passParam | while read num
  do
    insertSql "LoginLog.log.2012-03-"$num 2> /dev/null
  done
}
main