建表范范例，仅供自己备忘

# MySQL-Front 3.2  (Build 2.16)

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET CHARACTER SET 'gb2312' */;


# Host: 127.0.0.1    Database: jsp
# ------------------------------------------------------
# Server version 5.0.22-community-nt

CREATE DATABASE `jsp`;
USE `jsp`;

#
# Table structure for table news
#

CREATE TABLE `news` (
  `Id` int(6) unsigned NOT NULL auto_increment,
  `title` varchar(20) default NULL,
  `body` text,
  `time` varchar(20) default NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table news
#

INSERT INTO `news` VALUES (1,'dfdfdf','dfdfdfdfd','2007-12-10 12:20:12');
INSERT INTO `news` VALUES (2,'erer4343434','dfdvbrdfgfgf','2007-12-10 12:20:12');
INSERT INTO `news` VALUES (3,'dfdf','ddredfgfgfgfgfg','2007-12-10 12:20:12');
INSERT INTO `news` VALUES (4,'cdfdf','dddddeeeeeeeeeeeeeeeeeeee','2007-12-10 12:20:12');
INSERT INTO `news` VALUES (5,'dfdfdf','dfdfdfdfddfdfdfdf','2007-12-10 12:20:12');
INSERT INTO `news` VALUES (6,'333333333333','asfdgfgffffffffffff','2007-12-10 12:20:12');
INSERT INTO `news` VALUES (7,'d333333333333','dfdgfhbghjyhj0000000000000','2007-12-10 12:20:12');
INSERT INTO `news` VALUES (8,'woshiygegei','2007-12-10 12:20:12','2007-12-10 12:20:12');
INSERT INTO `news` VALUES (9,'laizilaobaixing','2007-12-10 12:20:12','2007-12-10 12:20:12');
INSERT INTO `news` VALUES (10,'d335645','df2007-12-10 12:20:12','2007-12-10 12:20:12');
INSERT INTO `news` VALUES (11,'dfd34345','dfdf2007-12-10 12:20:12','2007-12-10 12:20:12');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;