Mysql 批量删除表中某一区间的所有数据

For example:

delete from table_name where id>10 and id<30;