blob: 199edf9d7587413516f4bfc4fb731f8272f6842b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
DROP TABLE IF EXISTS users;
FLUSH STATUS;
CREATE TABLE users (
age INT,
INDEX (age)
) DEFAULT CHARSET=UTF8;
INSERT INTO users (age) VALUES (28);
INSERT INTO users (age) VALUES (28);
INSERT INTO users (age) VALUES (29);
INSERT INTO users (age) VALUES (29);
INSERT INTO users (age) VALUES (29);
SELECT COUNT(*) FROM users WHERE age <> 29;
COUNT(*)
2
SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
Mroonga_count_skip 0
DROP TABLE users;
|