blob: 45b3fbe122ad4586f64a86e985e027ab3c02d4ab (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
DROP TABLE IF EXISTS ids;
SET NAMES UTF8;
CREATE TABLE ids (
id INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT,
value INT(10),
INDEX (value)
) ENGINE=Mroonga DEFAULT CHARSET=utf8;
INSERT INTO ids VALUES(1, 50);
INSERT INTO ids VALUES(2, 70);
INSERT INTO ids VALUES(3, 30);
INSERT INTO ids VALUES(4, 90);
INSERT INTO ids VALUES(5, 10);
SELECT id, value FROM ids WHERE value < 90 ORDER BY value ASC LIMIT 3;
id value
5 10
3 30
1 50
DROP TABLE ids;
|
