Shell 编写技巧 集锦

1、mysql查询

mysql="mysql -uroot -p$MYSQL_ROOT_PASSWORD -S /var/run/mysqld/mysqld.sock -A -N"
sql="SELECT count(*) FROM information_schema.SCHEMATA where SCHEMA_NAME='zen'"
result="$($mysql -e "$sql")"

if [ "$result" == "1" ]; then
    exec java -Djava.security.egd=file:/dev/./urandom -jar /_appDatas/p_App.jar >/applogs/${c_name}.log
fi