数据库结构如下
如果是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