DB_51Aspx/bookms.sql

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
 Navicat Premium Data Transfer

 Source Server         : MySQL5.7
 Source Server Type    : MySQL
 Source Server Version : 50739 (5.7.39)
 Source Host           : localhost:3306
 Source Schema         : bookms

 Target Server Type    : MySQL
 Target Server Version : 50739 (5.7.39)
 File Encoding         : 65001

 Date: 27/06/2024 17:53:31
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `press` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of book
-- ----------------------------
INSERT INTO `book` VALUES (1, '红楼梦', '曹雪芹', '人民文学出版社');
INSERT INTO `book` VALUES (2, '西游记', '昊承恩', '中华书局');
INSERT INTO `book` VALUES (3, '水浒传', '施耐庵', '人民文学出版社');
INSERT INTO `book` VALUES (4, '三国演义', '罗贯中', '中华书局');
INSERT INTO `book` VALUES (5, '百年孤独', '加西亚·马尔克斯', '南海出版社');
INSERT INTO `book` VALUES (6, '追风筝的人', '卡勒德·胡赛尼', '上海人民出版社');
INSERT INTO `book` VALUES (7, '小王子', '安托万·德·圣-埃克苏佩里', '译林出版社');
INSERT INTO `book` VALUES (8, '1984', '乔治·奥威尔', '译林出版社');
INSERT INTO `book` VALUES (9, '简爱', '夏洛蒂·勃朗特', '人民文学出版社');
INSERT INTO `book` VALUES (10, '·了不起的盖茨比', 'F.斯科特·菲茨杰拉德', '上海译文出版社');
INSERT INTO `book` VALUES (11, '时间简史', '斯蒂芬·威廉·霍金', '湖南科学技术出版社');
INSERT INTO `book` VALUES (12, '思考，快与慢', '丹尼尔·卡尼曼', '中信出版社');
INSERT INTO `book` VALUES (13, '活着', '余华', '作家出版社');
INSERT INTO `book` VALUES (14, '人类简史', '尤瓦尔·赫拉利', '中信出版社');
INSERT INTO `book` VALUES (15, '51aspx', 'MVP', '人民出版社');

SET FOREIGN_KEY_CHECKS = 1;