blob: eaf5b87e62c80b339e9942ad4c60dfae7be37833 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
DROP TABLE IF EXISTS ids;
SET NAMES UTF8;
CREATE TABLE ids (
id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT
) ENGINE=Mroonga DEFAULT CHARSET=utf8;
INSERT INTO ids VALUES();
INSERT INTO ids VALUES();
INSERT INTO ids VALUES();
INSERT INTO ids VALUES();
INSERT INTO ids VALUES();
SELECT * FROM ids WHERE ids.id < 4 ORDER BY ids.id DESC LIMIT 3;
id
3
2
1
DROP TABLE ids;
|
