EMQX数据持久化到mysql

EMQX企业版支持将mqtt数据持久化mysql数据库，没License最多支持10个设备接入
1、连接mysql数据库

2、添加规则
提取MQTT消息主题

将mqtt消息保存到mysql数据表格的SQL示例

INSERT INTO data(dev_id,voltage,current,temperature,slot,curr_temp,target_temp,mode,menu,run,seg,P,I,D,arrived)
VALUES(${clientid},${payload.voltage},${payload.current},${payload.temperature},${payload.slot},${payload.work.curr_temp},${payload.work.target_temp},${payload.work.mode},${payload.work.menu},${payload.work.run},${payload.work.seg},${payload.work.P},${payload.work.I},${payload.work.D},FROM_UNIXTIME(${timestamp}/1000))

查看存储数据