mysql命令

建立数据库：

CREATE DATABASE `company` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

建立表user（用户信息）：

CREATE TABLE `company`.`user` (

`uid` INT( 5 ) NOT NULL AUTO_INCREMENT ,

`name` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,

`pass` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,

PRIMARY KEY ( `uid` )

) ENGINE = InnoDB;

表message（用户留言详情）：

CREATE TABLE `company`.`message` (

`author` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,

`title` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,

`content` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,

`date` DATE NOT NULL

) ENGINE = InnoDB;