mysql> CREATE TABLE `mepa_inews` (`id` tinyint unsigned NOT NULL auto_increment, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0.67 sec) mysql> INSERT INTO mepa_inews VALUES(''),(''),(''),(''),(''),(''),(''),(''),(''),(''),(''),(''),(''),(''),(''); Query OK, 15 rows affected, 15 warnings (0.01 sec) Records: 15 Duplicates: 0 Warnings: 0 mysql> SELECT * FROM mepa_inews; +----+ | id | +----+ | 1 | | 2 | | 3 | | 4 | | 5 | | 6 | | 7 | | 8 | | 9 | | 10 | | 11 | | 12 | | 13 | | 14 | | 15 | +----+ 15 rows in set (0.00 sec) mysql> DELETE FROM mepa_inews ORDER BY id DESC LIMIT 5; Query OK, 5 rows affected (0.02 sec) mysql> SELECT * FROM mepa_inews; +----+ | id | +----+ | 1 | | 2 | | 3 | | 4 | | 5 | | 6 | | 7 | | 8 | | 9 | | 10 | +----+ 10 rows in set (0.00 sec) mysql> DELETE FROM mepa_inews ORDER BY id ASC LIMIT 5; Query OK, 5 rows affected (0.00 sec) mysql> SELECT * FROM mepa_inews; +----+ | id | +----+ | 6 | | 7 | | 8 | | 9 | | 10 | +----+ 5 rows in set (0.00 sec)