20CN网络安全小组论坛 - 编程破解 - 删除异常温湿度记录

论坛: 编程破解标题: 删除异常温湿度记录

作者: SCANDISK [scandisk]

论坛用户

select DEVTIME,TEMPERATURE,HUMIDITY,TERMINALNAME FROM LB_WARNING_DATA WHERE DEVTIME>='2021-09-27 12:22:00' AND DEVTIME<='2021-09-27 12:25:00' and TERMINALNAME REGEXP '验收区3' /*查询异常报警记录*/

delete from lb_warning_data where DEVTIME>='2021-09-27 12:22:00' AND DEVTIME<='2021-09-27 12:25:00' and TERMINALNAME REGEXP '验收区3' /*删除异常报警记录*/

SELECT DEVTIME,TEMPERATURE,HUMIDITY,TERMINALNAME from data_home where devtime>='2021-09-27 12:22:00' and DEVTIME<='2021-09-27 12:25:00' and TERMINALNAME REGEXP '验收区3' /*查询异常温湿度记录*/

delete from data_home where devtime>='2021-09-27 12:22:00' and DEVTIME<='2021-09-27 12:25:00' and TERMINALNAME REGEXP '验收区3' /*删除异常温湿度记录*/

地主发表时间: 21-10-08 09:11

论坛: 编程破解