mysql 批量update

UPDATE t_a AS source ,(SELECT id FROM t_a WHERE MONTH ='2013-11' AND
neId IN (SELECT id FROM t_n WHERE ip IN(
'17.4.23.23','17.4.12.45'
))) AS temp SET VALUE=
'a'
WHERE MONTH ='2013-11' AND source.id = temp.id

通过子查询结果作为临时表，然后作为条件；mysql的update 不支持in操作。