论坛: 编程破解 标题: 数据填充，移花接木。 复制本贴地址    
作者: SCANDISK [scandisk]    论坛用户   登录
CREATE TEMPORARY TABLE TEMPB SELECT DISTINCT devtime,terminalname,temperature,humidity FROM data_home where devtime>='2022-03-05 10:12:00' and  DEVTIME<='2022-03-05 10:55:00' and TERMINALNAME REGEXP '中药库18'
UPDATE TEMPB SET devtime=insert(devtime,1,10,'2022-03-06') where  DATE_FORMAT(devtime,'%Y-%m-%d')='2022-03-05';
/*UPDATE TEMPB SET devtime=insert(devtime,1,10,'2021-12-31') where  DATE_FORMAT(devtime,'%Y-%m-%d')='2022-01-02';*/

UPDATE data_home as A,TEMPB as B set A.temperature=B.temperature,A.humidity=B.humidity where A.devtime=b.devtime and A.devtime>='2022-03-06 10:12:00' and  A.DEVTIME<='2022-03-06 10:55:00' and A.TERMINALNAME REGEXP '中药库18' AND A.temperature<>B.temperature;

DROP TABLE TEMPB;

SELECT * FROM TEMPB;


select devtime,terminalname,temperature,humidity from data_home where devtime>'2021-12-30 10:00:00' and DEVTIME<'2021-12-31 10:32:00' and TERMINALNAME REGEXP '中药库18';

select DISTINCT devtime,terminalname,temperature,humidity from data_home where devtime>'2022-01-01 10:00:00' and DEVTIME<'2022-01-02 10:32:00' and TERMINALNAME REGEXP '中药库18';

update data_home set humidity=67.4 where devtime='2022-03-07 06:50:00' and TERMINALNAME REGEXP '验收区3'




地主 发表时间: 22-03-17 00:54

论坛: 编程破解

20CN网络安全小组版权所有
Copyright © 2000-2010 20CN Security Group. All Rights Reserved.
论坛程序编写：NetDemon

粤ICP备05087286号