CREATE TABLE `sys_log` (
`LogDate` datetime DEFAULT NULL,
`Level` varchar(255) DEFAULT NULL,
`Logger` varchar(255) DEFAULT NULL,
`Message` varchar(4000) DEFAULT NULL,
`Exception` varchar(2000) DEFAULT NULL,
`IP` varchar(300) DEFAULT NULL,
`Port` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;mysql数据库不懂, 这个是啥意思?
数据脚本
建表脚本
`LogDate` datetime DEFAULT NULL,
`Level` varchar(255) DEFAULT NULL,
`Logger` varchar(255) DEFAULT NULL,
`Message` varchar(4000) DEFAULT NULL,
`Exception` varchar(2000) DEFAULT NULL,
`IP` varchar(300) DEFAULT NULL,
`Port` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;mysql数据库不懂, 这个是啥意思?
数据脚本
建表脚本
解决方案 »
- 请求高手解决问题,蹊跷问题
- 如何在过程中调用过程,被调用的过程名作为参数传入?
- lock_sga=true后数据库不能正常启动
- 我想到上海工作,给个意见?不好意思,占这里的地方
- 类型转换----有要求的 把空数据转换0 在查询SELECT语句中完成转换
- sql语句的疑惑
- oracle 8居然不支持left join关键字,这可是sql92标准啊
- oracle本身带有报表工具马?我听说一个ORACLE REPROTE BUILDER,是什么?
- 如何实现把一个用户下的所有的对象(表、视图等)导入到另一个新建的用户下?
- 那位高手知道oracle存储过程如何加密呀???
- 求指教,这样的语句怎么写
- 在linux下安装oracle ,哪位有完整的并可运行的安装步骤吗,在线等
不会mysql
咋发到oracle板块来了
WITH T1 AS
(SELECT *
FROM (SELECT (SELECT MIN(LOGDATE) FROM SYS_LOG) +
(LEVEL - 1) / 24 / 60 / 60 LOGDATE
FROM DUAL
CONNECT BY LEVEL - 1 <= (SELECT (MAX(LOGDATE) - MIN(LOGDATE)) * 24 * 60 * 60
FROM SYS_LOG)),
(SELECT DISTINCT IP FROM SYS_LOG))
SELECT A.*
FROM T1 A, SYS_LOG B
WHERE A.LOGDATE = B.LOGDATE(+)
AND A.IP = B.IP(+)
AND B.IP IS NULL
WITH sys_log AS
(SELECT to_date('1022','miss') logdate, '192.168.7.333' ip,'33333' port,'嘻嘻嘻嘻嘻嘻嘻嘻' describe FROM dual UNION ALL
SELECT to_date('1022','miss') logdate, '192.168.7.222' ip,'22222' port,'嘻嘻嘻嘻嘻嘻嘻嘻' describe FROM dual UNION ALL
SELECT to_date('1023','miss') logdate, '192.168.7.111' ip,'11111' port,'嘻嘻嘻嘻嘻嘻嘻嘻' describe FROM dual UNION ALL
SELECT to_date('1023','miss') logdate, '192.168.7.222' ip,'22222' port,'嘻嘻嘻嘻嘻嘻嘻嘻' describe FROM dual UNION ALL
SELECT to_date('1024','miss') logdate, '192.168.7.111' ip,'11111' port,'嘻嘻嘻嘻嘻嘻嘻嘻' describe FROM dual UNION ALL
SELECT to_date('1025','miss') logdate, '192.168.7.111' ip,'11111' port,'嘻嘻嘻嘻嘻嘻嘻嘻' describe FROM dual
),
T1 AS
(SELECT *
FROM (SELECT (SELECT MIN(LOGDATE) FROM SYS_LOG) +
(LEVEL - 1) / 24 / 60 / 60 LOGDATE
FROM DUAL
CONNECT BY LEVEL - 1 <= (SELECT (MAX(LOGDATE) - MIN(LOGDATE)) * 24 * 60 * 60
FROM SYS_LOG)),
(SELECT DISTINCT IP FROM SYS_LOG))
SELECT *
FROM T1 A, SYS_LOG B
WHERE A.LOGDATE = B.LOGDATE(+)
AND A.IP = B.IP(+)
AND B.IP IS NULL