将mysql数据导入redis

文件：mysql_to_redis.sql 

SELECT CONCAT(

  "*8\r\n",
  '$', LENGTH(redis_cmd), '\r\n',  redis_cmd, '\r\n',
  '$', LENGTH(redis_key), '\r\n',  redis_key, '\r\n',
  '$', LENGTH(hkey2), '\r\n',  hkey2, '\r\n',
  '$', LENGTH(hval2), '\r\n',  hval2, '\r\n'
  '$', LENGTH(hkey3), '\r\n',  hkey3, '\r\n',
  '$', LENGTH(hval3), '\r\n',  hval3, '\r\n'
  '$', LENGTH(hkey4), '\r\n',  hkey4, '\r\n',
  '$', LENGTH(hval4), '\r\n',  hval4, '\r'
)
FROM (
  SELECT 'HMSET' as redis_cmd,
  CONCAT(id,'_cms_account') AS redis_key,
  'username' as hkey2,   username AS hval2,
  'uid' as hkey3,   uid as hval3,
  'productid' as hkey4,   productid as hval4
  FROM cms_account 

) AS t

命令：

D:\redis-2.8\bin\release\redis-2.8.16>mysql -h192.168.101.192 -uroot  -p    dbname --skip-column-names --raw < mysql_to_redis.sql  | redis-cli --pipe