数据库设置
CREATE DATABASE dbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
数据表设置
CREATE TABLE `guestbook` (
`id` int(10) unsigned PRIMARY KEY AUTO_INCREMENT,
`nickname` char(16) NOT NULL DEFAULT '',
`email` varchar(60) DEFAULT NULL,
`content` text NOT NULL,
`createtime` int(10) unsigned NOT NULL DEFAULT '0',
`reply` text DEFAULT NULL,
`replytime` int(10) unsigned DEFAULT NULL,
`status` tinyint(1) unsigned DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
mysql中两种数据库引擎
ENGINE=MyISAM
ENGINE=InnoDB