【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,create_books.sql,希望对大家有所帮助!
CREATE TABLE `books` (
`book_id` varchar(11) CHARACTER SET utf8 NOT NULL,
`book_Name` varchar(150) CHARACTER SET utf8 DEFAULT NULL,
`book_Author` varchar(150) CHARACTER SET utf8 DEFAULT NULL,
`book_Publish` varchar(150) CHARACTER SET utf8 DEFAULT NULL,
`book_date` datetime DEFAULT NULL,
`book_isbn` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
`book_page` int(11) DEFAULT NULL,
`book_Price` decimal(10,2) DEFAULT NULL,
`book_content` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`book_id`)
)