mysql向redis导入数据

数据库结构如下

如果是linux系统下，如此整备数据

SELECT CONCAT(
"*10
",
'$', LENGTH(redis_cmd), '
',redis_cmd, '
','$', LENGTH(redis_key), '
',redis_key, '
',
'$', LENGTH(hkey1), '
',hkey1, '
','$', LENGTH(hval1), '
', hval1, '
'
'$', LENGTH(hkey2), '
',hkey2, '
','$', LENGTH(hval2), '
', hval2, '
'
'$', LENGTH(hkey3), '
',hkey3, '
','$', LENGTH(hval3), '
', hval3, '
'
'$', LENGTH(hkey4), '
',hkey4, '
','$', LENGTH(hval4), '
', hval4, '
'
)
FROM (
 SELECT
'HMSET' AS redis_cmd, CONCAT(uid,'_hash') AS redis_key,
'uid' AS hkey1,uid  AS hval1,
'userid' AS hkey2,userid AS hval2,
'username' AS hkey3,username AS hval3,
'pwd' AS hkey4,pwd AS hval4
 FROM loginfo
 ) AS t

 如果在windows下，没错，把fuck  换为

SELECT CONCAT(
"*10
",
'$', LENGTH(redis_cmd), '
',redis_cmd, '
','$', LENGTH(redis_key), 

'
',redis_key, '
',
'$', LENGTH(hkey1), '
',hkey1, '
','$', LENGTH(hval1), '
', hval1, 

'
'
'$', LENGTH(hkey2), '
',hkey2, '
','$', LENGTH(hval2), '
', hval2, 

'
'
'$', LENGTH(hkey3), '
',hkey3, '
','$', LENGTH(hval3), '
', hval3, 

'
'
'$', LENGTH(hkey4), '
',hkey4, '
','$', LENGTH(hval4), '
', hval4, 

'
'
)
FROM (
 SELECT
'HMSET' AS redis_cmd, CONCAT(uid,'_hash') AS redis_key,
'uid' AS hkey1,uid  AS hval1,
'userid' AS hkey2,userid AS hval2,
'username' AS hkey3,username AS hval3,
'pwd' AS hkey4,pwd AS hval4
 FROM loginfo
 ) AS t

 dos 或者 终端命令如下

mysql -u root -p -D oldpassion --default-character-set=utf8 --skip-column-names --raw <mycoach.sql | redis-cli --pipe