mysql中錯誤：1093-Youcan’tspecifytargettableforupdateinFROMclause的解決方法

UPDATE f_student
SET school_id = 0
WHERE
 id > (
 SELECT
 id
 FROM
 f_student
 WHERE
 school_id = M
 LIMIT 1
 )
AND id < (
 (
 SELECT
 id
 FROM
 f_student
 WHERE
 school_id = M
 LIMIT 1
 ) + N
)

[Err] 1093 – You can't specify target table ‘f_student' for update in FROM clause

UPDATE f_student SET school_id = 0 WHERE
 id > 
 (
 SELECT id FROM ( 
 SELECT id FROM f_student WHERE school_id = M LIMIT 1 
 ) AS temp 
 )
 AND id <
 (
 (
 SELECT id FROM ( 
 SELECT id FROM f_student WHERE school_id = M LIMIT 1 
 ) AS temp_1 
 ) + N
 )