两个示例,见附件。
DROP TABLE IF EXISTS `game`.`books`;
CREATE TABLE `game`.`books` (
`book_id` int(11) NOT NULL default '0',
`book_name` varchar(200) default NULL,
`book_author` varchar(100) default NULL,
`book_publish` varchar(100) default NULL,
`book_date` date default NULL,
`book_isbn` varchar(20) default NULL,
`book_page` int(11) default NULL,
`book_price` decimal(10,2) default NULL,
`book_content` varchar(100) default NULL,
PRIMARY KEY (`book_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;