All pastes #190417 Raw Edit

Ryan

public sql v1 · immutable
·published 2006-10-03 23:31 UTC
rendered paste body
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: 0mysql> 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)