--合并关键字的命中率到一个字段
update table b set b.times=(
select c.cout from (
select a.keyword,count(*) as cout,min(a.rowid) as temprowid from table a group by a.keyword
) c
where b.rowid=c.temprowid)
where b.rowid in (select c.temprowid from (select a.keyword,count(*) as cout,min(a.rowid) as temprowid from table a group by a.keyword) c)
update Table b set b.times=(
select count(*) from Table a group by a.keyword
where a.rowid= )
where b.rowid =