1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
|
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (
id INT PRIMARY KEY AUTO_INCREMENT,
c1 VARCHAR(10),
c2 VARCHAR(10),
KEY idx1(c1, c2)
) DEFAULT CHARSET UTF8;
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`c1` varchar(10) DEFAULT NULL,
`c2` varchar(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx1` (`c1`,`c2`)
) ENGINE=Mroonga DEFAULT CHARSET=utf8mb3
INSERT INTO t1 (c1, c2) VALUES
('1999', '12'),
('2000', '11'),
('2001', '10'),
('2002', '09'),
('2003', '08'),
('2004', '07'),
('2005', '06'),
('2006', '05'),
('2007', '04'),
('2008', '03'),
('2009', '02'),
('2010', '01');
SELECT * FROM t1 WHERE c1 > '2005';
id c1 c2
8 2006 05
9 2007 04
10 2008 03
11 2009 02
12 2010 01
SELECT * FROM t1 WHERE c1 >= '2005';
id c1 c2
7 2005 06
8 2006 05
9 2007 04
10 2008 03
11 2009 02
12 2010 01
SELECT * FROM t1 WHERE c1 = '2005';
id c1 c2
7 2005 06
SELECT * FROM t1 WHERE c1 <= '2005';
id c1 c2
1 1999 12
2 2000 11
3 2001 10
4 2002 09
5 2003 08
6 2004 07
7 2005 06
SELECT * FROM t1 WHERE c1 < '2005';
id c1 c2
1 1999 12
2 2000 11
3 2001 10
4 2002 09
5 2003 08
6 2004 07
DROP TABLE t1;
|