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

最新推荐文章于 2022-05-25 19:29:08 发布

转载最新推荐文章于 2022-05-25 19:29:08 发布 · 134 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/dreamVip/blog/1550345

文章标签：

#数据库 #shell

本文介绍了一个用于从MySQL和Redis数据库中删除特定用户数据的Shell脚本。该脚本通过MD5加密用户电话号码和ID号来定位并删除对应记录，并在Redis中删除相关的键值。脚本首先在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 <<EOF
auth '${redisPass}'
keys pre_userbaseinfo_*
del "${myMd5}"
EOF
echo "======================================脚本执行结束========================================"
else
echo "Not mobilePhone paramaters"
fi

转载于:https://my.oschina.net/dreamVip/blog/1550345