Skip to content

sql

Jump to bottom
gcht edited this page Aug 3, 2017 · 3 revisions

select b.id, a.id,a.question as q, b.question as qs, a.answer from ybzkb.qa a left join ybzkb.qa_similar b on a.id=b.qid where b.question like '%税%' group by b.id order by a.id

QA数据清理

  • select * from yycloudkb.qa;

  • select * from yycloudkb.qa where question is null or question='';

  • delete from yycloudkb.qa where question is null or question='';

  • select * from yycloudkb.qa_similar where question is null or question='';

  • delete from yycloudkb.qa_similar where question is null or question='';

  • select * from yycloudkb.qa_similar where (qid not in (select id from yycloudkb.qa)) or (qid is null) or (qid='');

  • delete from yycloudkb.qa_similar where (qid not in (select id from yycloudkb.qa)) or (qid is null) or (qid='');

  • select b.id, a.id as q_id, b.qid,a.question as q, b.question as qs, a.answer, a.createTime from yycloudkb.qa_similar b left join yycloudkb.qa a on a.id=b.qid where b.question like '%%' group by b.id order by a.createTime desc

Clone this wiki locally