mysql和redis删除数据_简单shell 删除mysql redis 指定数据内容

#!/bin/bash

host_name='xxxxxxxxx'

username='xxxxxxxxx'

password='xxxxxxxxx'

database='xxxxxxxxx'

mysqlPort='xxxxxxxxx'

redisPath='~'

redisPass='xxxxxxxxx'

if [ -n "$1" ]; then

myMd5=$(echo "" | mysql -u${username} -p${password} -h${host_name} -P${mysqlPort} ${database} --default-character-set=utf8 -e "select concat('pre_userbaseinfo_',upper(md5(concat(phone,id_no)))) as '' from user_base_info where phone

='${1}'")

myMd5=${myMd5:1:49}

echo "redisKey-->$myMd5"

echo "====================================用户信息=========================================="

mysql -u${username} -p${password} -h${host_name} -P${mysqlPort} ${database} --default-character-set=utf8 -e "select * from user_base_info where phone="${1}""

mysql -u${username} -p${password} -h${host_name} -P${mysqlPort} ${database} --default-character-set=utf8 -e "delete from cl_user_borrow_channel where user_id=(select id from user where login_name='${1}')"

mysql -u${username} -p${password} -h${host_name} -P${mysqlPort} ${database} --default-character-set=utf8 -e "delete from user where login_name='${1}'"

mysql -u${username} -p${password} -h${host_name} -P${mysqlPort} ${database} --default-character-set=utf8 -e "DELETE from user_base_info where phone='${1}'"

echo "============================删除完成=====Redis 中现有的所有Keys==========================="

redis-cli <

auth '${redisPass}'

keys pre_userbaseinfo_*

del "${myMd5}"

EOF

echo "======================================脚本执行结束========================================"

else

echo "Not mobilePhone paramaters"

fi