07 2025 档案

mqtt发布服务和订阅信息命令
摘要：发布订阅服务：root@dell-PowerEdge-R740:/home/dell# mosquitto_sub -d -h 192.168.101.63 -p 1883 -t "lbmqtt" -u "root" -P "root" -v发送消息：mosquitto_pub -h 192.168 阅读全文
posted @ 2025-07-15 09:47 _Lawrence 阅读(6) 评论(0) 推荐(0)
mysql统计一周内每天的数据统计
摘要：WITH RECURSIVE dates AS ( SELECT CURDATE() - INTERVAL 6 DAY AS date -- 7天前 UNION ALL SELECT date + INTERVAL 1 DAY FROM dates WHERE date < CURDATE() -- 阅读全文
posted @ 2025-07-11 09:28 _Lawrence 阅读(13) 评论(0) 推荐(0)