建库建表
drop database if exists guest_book;
create database guest_book charset utf8;
use guest_book;
drop table if exists `guest_book`;
create table `guest_book` (
`id` int(10) unsigned not null auto_increment,
`name` varchar(20) not null default '' comment '姓名',
`email` varchar(30) not null default '' comment '邮箱',
`content` varchar(200) not null default '' comment '内容',
`add_time` datetime not null default '0000-00-00 00:00:00',
primary key (`id`)
) engine=innodb default charset=utf8 comment='留言表';
drop database if exists guest_book;
create database guest_book charset utf8;
use guest_book;
drop table if exists `guest_book`;
create table `guest_book` (
`id` int(10) unsigned not null auto_increment,
`name` varchar(20) not null default '' comment '姓名',
`email` varchar(30) not null default '' comment '邮箱',
`content` varchar(200) not null default '' comment '内容',
`add_time` datetime not null default '0000-00-00 00:00:00',
primary key (`id`)
) engine=innodb default charset=utf8 comment='留言表';