CheckIPAddress()
{
echo $1 |grep "^[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}$" > /dev/ null
if [ $? = 1 ]; then
return 1
else
a=`echo $1 | awk -F. '{print $1}'`
b=`echo $1 | awk -F. '{print $2}'`
c=`echo $1 | awk -F. '{print $3}'`
d=`echo $1 | awk -F. '{print $4}'`
#echo $a $b $c $d
for loop in $a $b $c $d
do
if [ $loop -ge 255 ] || [ $loop -lt 0 ]; then
return 2
fi
done
fi
}
ConfigureDefaultRegion() {
echo "Please input Region ip"
ret=1
while [ $ret != 0 ]
do
read region_ip
CheckIPAddress $region_ip
ret=$?
#echo $ret
if [ $ret = 1 ]; then
echo "Wrong IP address, please reinput Region IP:"
fi
done
/usr/bin/mysql -u root realworx_production -e " update regions set ip= '$region_ip' where id=1" 1>/dev/ null 2>/dev/ null
if [ $? = 0 ]; then
/usr/bin/mysql -u root realworx_production -e " update config_params set val=1 where ident=55" 1>/dev/ null 2>/dev/ null
echo " set '$region_ip' as Default and Admin Region IP"
else
val=`/usr/bin/mysql -u root realworx_production -e " select id from regions where ip= '$region_ip'" | awk '{if ($1 != "id") print $1}'`
/usr/bin/mysql -u root realworx_production -e " update config_params set val= '$val' where ident=55" 1>/dev/ null 2>/dev/ null
region_name=`/usr/bin/mysql -u root realworx_production -e " select name from regions where ip= '$region_ip'" | awk '{if ($1 != "name") print $1}'`
echo "IP already exists. So set '$region_name' as Admin Region. "
fi
echo "Region Setting Successfull."
}
{
echo $1 |grep "^[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}$" > /dev/ null
if [ $? = 1 ]; then
return 1
else
a=`echo $1 | awk -F. '{print $1}'`
b=`echo $1 | awk -F. '{print $2}'`
c=`echo $1 | awk -F. '{print $3}'`
d=`echo $1 | awk -F. '{print $4}'`
#echo $a $b $c $d
for loop in $a $b $c $d
do
if [ $loop -ge 255 ] || [ $loop -lt 0 ]; then
return 2
fi
done
fi
}
ConfigureDefaultRegion() {
echo "Please input Region ip"
ret=1
while [ $ret != 0 ]
do
read region_ip
CheckIPAddress $region_ip
ret=$?
#echo $ret
if [ $ret = 1 ]; then
echo "Wrong IP address, please reinput Region IP:"
fi
done
/usr/bin/mysql -u root realworx_production -e " update regions set ip= '$region_ip' where id=1" 1>/dev/ null 2>/dev/ null
if [ $? = 0 ]; then
/usr/bin/mysql -u root realworx_production -e " update config_params set val=1 where ident=55" 1>/dev/ null 2>/dev/ null
echo " set '$region_ip' as Default and Admin Region IP"
else
val=`/usr/bin/mysql -u root realworx_production -e " select id from regions where ip= '$region_ip'" | awk '{if ($1 != "id") print $1}'`
/usr/bin/mysql -u root realworx_production -e " update config_params set val= '$val' where ident=55" 1>/dev/ null 2>/dev/ null
region_name=`/usr/bin/mysql -u root realworx_production -e " select name from regions where ip= '$region_ip'" | awk '{if ($1 != "name") print $1}'`
echo "IP already exists. So set '$region_name' as Admin Region. "
fi
echo "Region Setting Successfull."
}
#shell mysql
****************************************
#!/bin/bash
olname=erik ##旧值,也就是要替换掉的值
nwname=erik ##新值,也就是要替换为的值
domain=@set-china.net ##后缀,此处是用来操作邮件的,其它用途可以不要或替换成其它
mysql -u root -p password <
##操作数据库的开始,此处输入用户名及密码,<
##<
use extmail;
show tables;
update alias set goto=REPLACE(goto,'$olname','$nwname$domain');
EOF
exit 0;
****************************************
##语句少的情况下可以如下使用
#!/bin/bash
mysql -u root -p password -e "use mysql;select * from user(SQL语句)";
exit 0;
****************************************
转载于:https://blog.51cto.com/horacelee/196315