1，根据需求，将需要导入redis的MySQL结果数据改变成redis格式数据
select concat(
"*22rn",
'$',length(redic_cmd),'rn',redic_cmd,'rn',
'$',length(concat(loginname,pwd)),'rn',concat(loginname,pwd),'rn',
'$',length(no1),'rn',no1,'rn',
'$',length(empid),'rn',empid,'rn',
'$',length(no2),'rn',no2,'rn',
'$',length(ruleid),'rn',ruleid,'rn',
'$',length(no3),'rn',no3,'rn',
'$',length(empname),'rn',empname,'rn',
'$',length(no4),'rn',no4,'rn',
'$',length(age),'rn',age,'rn',
'$',length(no5),'rn',no5,'rn',
'$',length(gender),'rn',gender,'rn',
'$',length(no6),'rn',no6,'rn',
'$',length(tel),'rn',tel,'rn',
'$',length(no7),'rn',no7,'rn',
'$',length(hiredate),'rn',hiredate,'rn',
'$',length(no8),'rn',no8,'rn',
'$',length(loginname),'rn',loginname,'rn',
'$',length(no9),'rn',no9,'rn',
'$',length(pwd),'rn',pwd,'rn',
'$',length(no10),'rn',no10,'rn',
'$',length(menuname),'rn',menuname,'r')
from
(select 'HMSET' as redic_cmd,'empid' as no1,'ruleid' no2,'empname' no3,'age' no4,'gender' no5,
'tel' no6,'hiredate' no7,'loginname' no8,'pwd' no9,'menuname' no10,
e.*,m.menuname from emp e inner join
(select r.ruleid,group_concat(m2.menuname) menuname from rule r inner join mfref m on r.ruleid = m.ruleid
inner join menus m2 on m.menuid = m2.menuid
group by m.ruleid) m on e.ruleid = m.ruleid) s;
2，上面内容存入为sql文件，上传到存入原数据的mysql的服务器中
首先在MySQL服务器上安装redis，无需启动，因为这里的安装只是需要一个redis的命令
# 添加软件安装源 yum install epel-release # 安装redis yum install redis -y
执行命令
#-D后为mysql的数据库名，后面IP是redis服务器的 mysql -uroot -pabc123 -Dexpenses --default-character-set=utf8 --skip-column-names --raw < /opt/emp.sql | redis-cli -h 192.168.187.120 --pipe
进入redis服务器，可用exists查看某一个键是否存在即可
