DROP TABLE IF EXISTS running_records;
CREATE TABLE running_records (
time TIME(6) PRIMARY KEY,
title TEXT
) DEFAULT CHARSET UTF8;
SHOW CREATE TABLE running_records;
Table	Create Table
running_records	CREATE TABLE `running_records` (
  `time` time(6) NOT NULL,
  `title` text,
  PRIMARY KEY (`time`)
) ENGINE=mroonga DEFAULT CHARSET=utf8
INSERT INTO running_records (time, title)
VALUES ("01:00:00.000001", "normal condition");
INSERT INTO running_records (time, title)
VALUES ("12:23:34.123456", "bad condition");
INSERT INTO running_records (time, title)
VALUES ("-838:59:59.000000", "record failure");
SELECT * FROM running_records;
time	title
-838:59:59.000000	record failure
01:00:00.000001	normal condition
12:23:34.123456	bad condition
SELECT * FROM running_records
WHERE time BETWEEN "00:59:59.999999" AND "12:23:34.123456";
time	title
01:00:00.000001	normal condition
12:23:34.123456	bad condition
DROP TABLE running_records;
