摘要:
create definer = root@`%` event t_repay_event on schedule every '1' DAY starts '2019-05-14 01:00:00' on completion preserve enable do call 存储过程test(); 阅读全文
摘要:
declare cursor c1 is select rowid from wjf.wjf_t01 where state is null; type typ_row_id is table of urowid index by binary_integer; v_doi typ_row_id; 阅读全文
摘要:
-- 分组取最后一条数据 搜索文字 -- 数据按小时分组,统计每分钟个数 搜索文字 -- 字符串转时间 STR_TO_DATE('2017-01-06 10:20:30','%Y-%m-%d %H:%i:%s') -- 取当天 to_days(create_dttm) = to_days(now() 阅读全文
摘要:
分组查询最新记录的两种方式##第一种select * from IVMP_DEVICE d, IVMP_DEVICE_STATE ds where d.DEVICE_SERIES = ds.DEVICE_SERIES and ds.HAPPEN_TIME = ( select max(HAPPEN_ 阅读全文