mysql删除数据表中 指定范围内的行数据

delete from cmf_guangnian_2 where exists (select * from (select g_id from cmf_guangnian_2 limit 10001,19292) as a where a.g_id=cmf_guangnian_2.g_id);