update sp_poem_check as a
set poem_id =(select p.id from sp_poem as p where a.uid= p.uid and a.poet_id =p.poet_id andwhere a.poem_id = 0
update sp_poet_check as a
set poet_id =(select p.id from sp_poet as p where a.uid= p.uid and a.born_year =p.born_year and
a.name =
p.name and a.born_dynasty = p.born_dynasty and a.die_year = p.die_year and a.die_dynasty = p.die_dynasty)
where a.poet_id = 0
set poet_id =(select p.id from sp_poet as p where a.uid= p.uid and a.born_year =p.born_year and
where a.poet_id = 0