一、编写sql脚本,保存为m2r.sql文件
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,
CONCAT('upload_fault_', f.`car_id`) AS redis_key,
CONCAT(b.`source_address_int`,'_',b.`spn`,'_',b.`fmi`,'_',b.`symbol_code`) AS hkey,
CONCAT('{
"uploadFirstTime": 1551935412000,
"uploadLastTime": 1551938412000,
"faultId": "2018006",
"faultCode": "1117",
"faultDesc": "点火时断电 - 数据不稳定、间断或不正确。ECM 电源短暂降到 6.2 伏以下,或 ECM 不可以正常断电(钥匙开关关闭后保持蓄电池电压 30 秒 )",
"faultLevel": "D",
"id": 1,
"carId": "3",
"symbolCode": "B0305"
}') AS hval
FROM fault_info_new f left join fault_base b on f.`fault_id` = b.`id` where b.`symbol_code` is not null and b.`symbol_code` <> ''
) AS t
二、在服务器上执行命令
[appuser1@platform-010-030-050-179 ~]$ mysql -uroot -p123 -h 127.0.0.1 testdb --skip-column-names --raw < /app/appuser1/m2r.sql | /app/redis/redis-3.0.7/bin/redis-cli -p 6379 -a 123456 --pipe