shell 脚本 连接数据库 

 1 #!/bin/bash
 2 f=$1
 3 d=$2
 4 # 20121212
 5 
 6 if [ "${f}" == "" ]; then
 7     f="/application/search/sitedb/out.map."`date "+%Y%m%d"`
 8 fi
 9 if [ "${d}" == "" ]; then
10     d=`date "+%Y%m%d %H:%M:%S"`
11 fi
12 echo $d
13 do=${d:0:8}
14 
15 echo $do
16 
17 end=`date --date "${do}" -u "+%s"`
18 start=$((end - 86400))
19 echo $end
20 :<<block
21 # echo ${start}
22 # echo $end
23 
24 db="/application/search/package/mysql/bin/mysql -h -u search -P 3306 -p\"passwd \""
25 while read url time path status other
26 do
27     # echo $line | awk -F'\t' '{print $1
28     # echo $line
29     # echo "$url\t$time\t$path\t$status\n"
30     if [ $time -lt $start -o $time -ge $end ]; then
31         continue
32     fi
33     domain=""
34     sql1="replace into SavedPath_info values(\"$domain\",\"$url\",\"${d}\",\"SavedPath\", \"$path\");"
35     sql2="update Brief_info set Access=$status, SavedHost="", SavedPath=\"$path\" where url=\"$url\"" 
36     # echo $sql1
37     # echo $sql2
38     echo $sql1 | /application/search/liuxinbin/package/mysql/bin/mysql -h  -u search -P 3306 DB -p"passwd"
39     echo $sql2 | /application/search/liuxinbin/package/mysql/bin/mysql -h  -u search -P 3306 DB -p"passwd"
40 done < $f
41 block

1,注释的使用方法。

2，时间操作的方法。

3，mysql 连接数据库的方法

posted on 2013-04-02 14:23  Harveyaot  阅读(566)  评论(0)    收藏  举报

导航