更新预测原因ac 的sql

[zhanyeye]

select ac_record_id, vote_id FROM vote_detail WHERE ac_record_id is not null


SELECT id from vote WHERE external = 0

SELECT v.id, p.title from paper p LEFT JOIN vote v on p.vote_id = v.id 


SELECT * FROM (select ac_record_id, vote_id FROM vote_detail WHERE ac_record_id is not null
) A INNER JOIN (SELECT v.id, p.title from paper p LEFT JOIN vote v on p.vote_id = v.id ) B on A.vote_id = B.id


UPDATE ac_record a, (SELECT * FROM (select ac_record_id, vote_id FROM vote_detail WHERE ac_record_id is not null
) A INNER JOIN (SELECT v.id, p.title from paper p LEFT JOIN vote v on p.vote_id = v.id ) B on A.vote_id = B.id) tmp set a.reason = CONCAT(tmp.title, a.reason) WHERE a.id = tmp.ac_record_id

SELECT v.id, p.title from external_paper p LEFT JOIN vote v on p.vote_id = v.id 


SELECT * FROM (select ac_record_id, vote_id FROM vote_detail WHERE ac_record_id is not null
) A INNER JOIN (SELECT v.id, p.title from external_paper p LEFT JOIN vote v on p.vote_id = v.id ) B on A.vote_id = B.id


UPDATE ac_record a, (SELECT * FROM (select ac_record_id, vote_id FROM vote_detail WHERE ac_record_id is not null
) A INNER JOIN (SELECT v.id, p.title from external_paper p LEFT JOIN vote v on p.vote_id = v.id ) B on A.vote_id = B.id) tmp set a.reason = CONCAT(tmp.title, a.reason) WHERE a.id = tmp.ac_record_id