yoni

[Day : 00~24시] #daySELECT '00' AS BASE_HOURUNION ALLSELECT '01' AS BASE_HOURUNION ALLSELECT '02' AS BASE_HOURUNION ALLSELECT '03' AS BASE_HOURUNION ALLSELECT '04' AS BASE_HOURUNION ALLSELECT '05' AS BASE_HOURUNION ALLSELECT '06' AS BASE_HOURUNION ALLSELECT '07' AS BASE_HOURUNION ALLSELECT '08' AS BASE_HOURUNION ALLSELECT '09' AS BASE_HOURUNION ALLSELECT '10' AS BASE_HOURUNION ALLSELECT '11' AS B..

[SENSOR_DATA, SENSOR_DATA2셀에 입력된 데이터를 (null)로 나오게] update SENSOR_DATASET SENSOR_DATA = NULL, SENSOR_DATA2 = NULLWHERE SENSOR_ID='NS01' AND SENSOR_TYPE='a03' AND REG_DATETIME='2017-10-18 03:00:00'