news.sql

来自「< JAVA ME 手机应用开发技术月案例详解>>一书中的一个」· SQL 代码 · 共 40 行

# MySQL-Front 3.2  (Build 6.2)

/*!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: news
# ------------------------------------------------------
# Server version 5.0.20-nt

DROP DATABASE IF EXISTS `news`;
CREATE DATABASE `news` /*!40100 DEFAULT CHARACTER SET gb2312 */;
USE `news`;

#
# Table structure for table newsinfo
#

CREATE TABLE `newsinfo` (
  `Id` int(6) unsigned NOT NULL auto_increment,
  `newstitle` varchar(20) NOT NULL default '',
  `Date` date NOT NULL default '0000-00-00',
  `context` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table newsinfo
#

INSERT INTO `newsinfo` (`Id`,`newstitle`,`Date`,`context`) VALUES (1,'胡连会','2006-04-29','胡连会');
INSERT INTO `newsinfo` (`Id`,`newstitle`,`Date`,`context`) VALUES (2,'五四青年节','2006-05-04','今天是五四青年节');
INSERT INTO `newsinfo` (`Id`,`newstitle`,`Date`,`context`) VALUES (3,'五四青年节','2006-05-04','今天是五四青年节');
INSERT INTO `newsinfo` (`Id`,`newstitle`,`Date`,`context`) VALUES (4,'五四青年节','2006-05-04','今天是五四青年节');

/*!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 */;