DROP TEMPORARY TABLE IF EXISTS diaries;
CREATE TEMPORARY TABLE diaries (
id INT PRIMARY KEY AUTO_INCREMENT,
title TEXT
) DEFAULT CHARSET=UTF8;
SHOW CREATE TABLE diaries;
Table	Create Table
diaries	CREATE TEMPORARY TABLE `diaries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text,
  PRIMARY KEY (`id`)
) ENGINE=mroonga DEFAULT CHARSET=utf8
INSERT INTO diaries (title) VALUES ("clear day");
INSERT INTO diaries (title) VALUES ("rainy day");
INSERT INTO diaries (title) VALUES ("cloudy day");
SELECT * FROM diaries;
id	title
1	clear day
2	rainy day
3	cloudy day
DROP TEMPORARY TABLE diaries;
