redis 批量导入

最新推荐文章于 2024-01-21 18:20:52 发布

zhaokuner

最新推荐文章于 2024-01-21 18:20:52 发布

阅读量748

点赞数

分类专栏： mysql linux

本文链接：https://blog.csdn.net/zhaokuner/article/details/23342675

版权

linux 同时被 2 个专栏收录

33 篇文章 0 订阅

订阅专栏

mysql

7 篇文章 0 订阅

订阅专栏

redis 官方方式：http://www.redis.cn/topics/mass-insert.html

sh脚本执行mysql 语句

#!/bin/sh


date +%s ;


/usr/bin/mysql -h************ -P3306 -uucenter -panzhi <<EOF
use ucenter;
select  "*8",concat('$','5'),"HMSET",concat('$','8'),"testtest",

concat('$',IFNULL(length(login_name),0)),IFNULL(login_name,''),

concat('$',IFNULL(length(id),0)),IFNULL(id,''),

concat('$',IFNULL(length(email),0)),IFNULL(email,''),

concat('$',IFNULL(length(id),0)),IFNULL(id,''),

concat('$',IFNULL(length(telphone),0)),IFNULL(telphone,''),

concat('$',IFNULL(length(id),0)),IFNULL(id,'')

INTO OUTFILE '/tmp/data.txt' FIELDS TERMINATED BY '\r\n' LINES TERMINATED BY '\r\n'
from u_bbs_passport_manage ;
quit
EOF
date +%s ;
echo 'bigen change'
#cat /tmp/data.txt | /usr/local/bin/redis-cli   --pipe  -h **********

其中

FIELDS TERMINATED BY ',' 字段间分割符
OPTIONALLY ENCLOSED BY '"' 将字段包围对数值型无效
LINES TERMINATED BY '\n' 换行符

生成的文件 data.txt

*8\r\n$5\r\nHMSET\r\n$8\r\ntesttest\r\n$5\r\nadmin\r\n$1\r\n1\r\n$0\r\n\r\n$1\r\n1\r\n$0\r\n\r\n$1\r\n1\r\n*8\r\n$5\r\nHMSET\r\n$8\r\ntesttest\r\n$3\r\n��N\r\n$1\r\n2\r\n$0\r\n\r\n$1\r\n2\r\n$0\r\n\r\n$1\r\n2\r\n

其中\r\n在文件中是看不到的被解析成换行了

执行

cat /tmp/data.txt | /usr/local/bin/redis-cli --pipe -h **********