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

Suppose the table is structured as follows

CREATE TABLE sas_sys_app (

user_id varchar(38) DEFAULT NULL,

app_id int(11) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8

Writing 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

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.