Mysql保留最新10条数据删除其他数据

DELETE A FROM Table_name A JOIN (SELECT id FROM table_name ORDER BY id DESC LIMIT 10,1) B WHERE A.id<=B.id