试试:
update table1 set kick = (select action_id from table2 where table2.action_id in(1,2,3) and table1.content_id = table2.content_id)
update table1 set kick = (select action_id from table2 where table2.action_id in(1,2,3) and table1.content_id = table2.content_id)
update table1 set kick = (select count(*) from table2 where table2.action_id in(1,2,3) and table1.content_id = table2.content_id)
where table1.content_id = table2.content_id