求最节省资源的sql。
建表语句——
CREATE TABLE `user` (
`uid` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(32) DEFAULT '',
`ages` int(3) DEFAULT NULL,
PRIMARY KEY (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
CREATE TABLE `thread` (
`tid` int(11) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(11) DEFAULT NULL,
`title` varchar(64) DEFAULT '',
`vies` int(8) DEFAULT '0',
PRIMARY KEY (`tid`)
) ENGINE=MEMORY AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;