20110619_留言版1建立資料庫及資料表

may

/* 建立資料庫 */
CREATE DATABASE customer_db;

/* 建立資料表 */
CREATE TABLE `guestbook_tab` (
`gb_no` INT NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT '留言編號',
`gb_name` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`gb_msg` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`gb_date` DATE NOT NULL ,
`gb_email` VARCHAR( 100 ) NOT NULL ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;