3,491
社区成员
发帖
与我相关
我的任务
分享
update urlnum u
set num =
(SELECT COUNT(*)
FROM js_chat_record
WHERE REFER_PAGE LIKE '%' || u.url || '%'
AND to_char(CREATE_TIME, 'yyyy-mm-dd') BETWEEN '2014-07-01' AND
'2014-08-01'
and effective > 0);
[/quote]
我也试过了可以查但是得不到数值,存不到数据库里。[/quote]
是不是你的子查询查不到数据?条件导致的?[/quote]
我之前数据库里放了一条数据的时候能查到数,而且数对上了。但是多条就报错了。[/quote]
你先用子查询进行查询测试吧,看能不能查出记录。就用你插入的那条数据来测试
update urlnum u
set num =
(SELECT COUNT(*)
FROM js_chat_record
WHERE REFER_PAGE LIKE '%' || u.url || '%'
AND to_char(CREATE_TIME, 'yyyy-mm-dd') BETWEEN '2014-07-01' AND
'2014-08-01'
and effective > 0);
[/quote]
我也试过了可以查但是得不到数值,存不到数据库里。[/quote]
是不是你的子查询查不到数据?条件导致的?[/quote]
我之前数据库里放了一条数据的时候能查到数,而且数对上了。但是多条就报错了。
update urlnum u
set num =
(SELECT COUNT(*)
FROM js_chat_record
WHERE REFER_PAGE LIKE '%' || u.url || '%'
AND to_char(CREATE_TIME, 'yyyy-mm-dd') BETWEEN '2014-07-01' AND
'2014-08-01'
and effective > 0);
[/quote]
我也试过了可以查但是得不到数值,存不到数据库里。[/quote]
是不是你的子查询查不到数据?条件导致的?
update urlnum u
set num =
(SELECT COUNT(*)
FROM js_chat_record
WHERE REFER_PAGE LIKE '%' || u.url || '%'
AND to_char(CREATE_TIME, 'yyyy-mm-dd') BETWEEN '2014-07-01' AND
'2014-08-01'
and effective > 0);
[/quote]
我也试过了可以查但是得不到数值,存不到数据库里。UPDATE
URLNUM
SET
NUM = (
SELECT COUNT(*) CNT
FROM JS_CHAT_RECORD J
WHERE EXISTS (
SELECT NULL
FROM URLNUM T
WHERE J.REFER_PAGE LIKE '%'||T.URL||'%'
AND TO_CHAR(CREATE_TIME,'yyyy-mm-dd') BETWEEN '2014-07-01' AND '2014-08-01'
AND EFFECTIVE > 0
)
);
update urlnum u
set num =
(SELECT COUNT(*)
FROM js_chat_record
WHERE REFER_PAGE LIKE '%' || u.url || '%'
AND to_char(CREATE_TIME, 'yyyy-mm-dd') BETWEEN '2014-07-01' AND
'2014-08-01'
and effective > 0);