CREATE TABLE `article` ( `id` INT(4) NOT NULL PRIMARY KEY auto_increment, `title` CHAR(20) NOT NULL, `content` CHAR(52) NOT NULL, `report_time` INT(11) NOT NULL DEFAULT ‘0‘ ) ENGINE=InnoDB DEFAULT CHARSET=utf8
原文：http://www.cnblogs.com/jiufen/p/5085817.html