Mysql MEMORYエンジン
2716 ワード
1 CREATE TABLE `m` (
2 `int` int(10) unsigned NOT NULL AUTO_INCREMENT,
3 `name` varchar(10) NOT NULL,
4 `ctime` int(10) NOT NULL,
5 `ltime` int(10) NOT NULL,
6 PRIMARY KEY (`int`),
7 UNIQUE KEY `name` (`name`),
8 KEY `idx_ctime` (`ctime`) USING BTREE,
9 KEY `idx_ltime` (`ltime`) USING HASH
10 ) ENGINE=MEMORY DEFAULT CHARSET=latin1