EVOLUTION-MANAGER

Edit File: column_date_with_index.result

DROP TABLE IF EXISTS diaries; CREATE TABLE diaries ( id INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(40), created_at DATE, KEY (created_at) ) DEFAULT CHARSET UTF8; SHOW CREATE TABLE diaries; Table Create Table diaries CREATE TABLE `diaries` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(40) DEFAULT NULL, `created_at` date DEFAULT NULL, PRIMARY KEY (`id`), KEY `created_at` (`created_at`) ) ENGINE=Mroonga DEFAULT CHARSET=utf8 INSERT INTO diaries (title, created_at) VALUES ("clear day", "2012-01-29"); INSERT INTO diaries (title, created_at) VALUES ("rainy day", "2012-01-30"); INSERT INTO diaries (title, created_at) VALUES ("cloudy day", "2012-01-31"); SELECT * FROM diaries; id title created_at 1 clear day 2012-01-29 2 rainy day 2012-01-30 3 cloudy day 2012-01-31 SELECT * FROM diaries WHERE created_at BETWEEN "2012-01-29" AND "2012-01-30"; id title created_at 1 clear day 2012-01-29 2 rainy day 2012-01-30 DROP TABLE diaries;