作者pennymarkfox (潘妮小狐狸)
看板Database
标题Re: [SQL ] data mining
时间Fri May 23 13:51:32 2008
嗯 用子查询好了
select id, key_index,
(select count(*) from content where word like '%' + key_index + '%') as col1
from key_data
嗯 如果要用inner join...
select t1.id, t1.key_index, count(*) as col1
from key_data t1
inner join content t2 on t2.word like '%' + t1.key_index + '%'
group by t1.id, t1.key_index
不过我是在sql server 2000上试的= = 我没有mysql
希望有帮到忙XD
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 118.231.55.87
※ 编辑: pennymarkfox 来自: 118.231.55.87 (05/23 14:05)
1F：推 wtuxxj:这样数值，你我他都是6耶~ 05/23 14:20