【SQL开源代码栏目提醒】:网学会员鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“guestbook.sql”一文,供大家参考学习
# MySQL-Front Dump 2.5
#
# Host: localhost Database: guestbook
# --------------------------------------------------------
# Server version 4.1.0-alpha-max-nt
CREATE DATABASE guestbook;
USE guestbook;
#
# Table structure for table 'guestbook'
#
DROP TABLE IF EXISTS guestbook;
CREATE TABLE guestbook (
id int(10) unsigned NOT NULL auto_increment,
firstName varchar(50) default NULL,
email varchar(50) default NULL,
comments text,
postDate datetime default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM CHARSET=latin1;
#
# Dumping data for table 'guestbook'
#
INSERT INTO guestbook (id, firstName, email, comments, postDate) VALUES("1", "John", "Joseph", "test data1", "2004-02-02 12:12:36");
INSERT INTO guestbook (id, firstName, email, comments, postDate) VALUES("2", "John", "Manavalan", "test data2", "2004-03-03 01:01:01");