SQL 建表 插数据

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

 

插数据

INSERT INTO `country` VALUES ('AU','Australia',18886000);
INSERT INTO `country` VALUES ('BR','Brazil',170115000);
INSERT INTO `country` VALUES ('CA','Canada',1147000);