Shulou(Shulou.com)06/01 Report--

This article is mainly about how to quickly import mysql data into redis cache. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic. I hope this article on how to quickly import mysql data into redis caching methods can bring you some practical help.

Suppose the table structure is as follows

CREATE TABLE sas_sys_app (

User_id varchar (38) DEFAULT NULL

App_id int (11) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8

Write sql files

SELECT CONCAT (

"* 4\ r\ n"

'$', LENGTH (redis_cmd),'\ r\ n'

Redis_cmd,'\ r\ n'

'$', LENGTH (redis_key),'\ r\ n'

Redis_key,'\ r\ n'

'$', LENGTH (hkey),'\ r\ n'

Hkey,'\ r\ n'

'$', LENGTH (hval),'\ r\ n'

Hval,'\ r'

)

FROM (

SELECT

'HSET' as redis_cmd

'hkey' AS redis_key

User_id AS hkey

App_id AS hval

FROM lumi_saas_access.sas_sys_app where company_id=64

) AS t

Execute import statement

Mysql-uadmin-h host-p database password library-- default-character-set=utf8-- skip-column-names-- raw < app2redis.sql | redis-cli-h redis-host-p 6379-- pipe

Mysql data fast import redis cache method to tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.