課程
/后端開發
/Java
/MyBatis-Plus + SpringBoot實現簡單權限管理
老師可以把帶有數據的sql發一下嗎？
2021-09-06
源自：MyBatis-Plus + SpringBoot實現簡單權限管理 6-3
正在回答
抱歉，這個不能發
老猿
自己造數據多好。
這是我造的數據
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for customer
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer`? (
? `customer_id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '真實姓名',
? `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性別',
? `age` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '年齡',
? `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '郵箱',
? `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手機號碼',
? `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地址',
? `create_time` datetime(0) NULL DEFAULT NULL COMMENT '創建時間',
? `modified_time` datetime(0) NULL DEFAULT NULL COMMENT '修改時間',
? `create_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '創建人',
? `modified_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '修改人',
? `deleted` tinyint(0) UNSIGNED NULL DEFAULT 0 COMMENT '邏輯刪除標識(0、否 1、是)',
? PRIMARY KEY (`customer_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '客戶表' ROW_FORMAT = Dynamic;
-- Records of customer
INSERT INTO `customer` VALUES (1, '張強', '男', 18, '[email protected]', '12580', '北京', '2021-09-29 10:55:22', NULL, NULL, NULL, 0);
INSERT INTO `customer` VALUES (2, '王偉', '男', 25, '[email protected]', '177777', '南京', '2021-09-29 10:55:54', NULL, NULL, NULL, 0);
SET FOREIGN_KEY_CHECKS = 1;
舉報
通過實戰項目掌握MyBatis-Plus應用！
1 回答數據庫沒有刪除
2 回答新添加數據有空數據字段時，無法查詢出來
1 回答數據直接添加了兩條數據？
2 回答sql問題
2 回答數據庫腳本
Copyright ? 2025 imooc.com All Rights Reserved | 京ICP備12003892號-11 京公網安備11010802030151號
購課補貼聯系客服咨詢優惠詳情
慕課網APP您的移動學習伙伴
掃描二維碼關注慕課網微信公眾號
2021-10-04
抱歉，這個不能發
2022-02-06
自己造數據多好。
這是我造的數據
2021-09-29
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for customer
-- ----------------------------
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer`? (
? `customer_id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '真實姓名',
? `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性別',
? `age` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '年齡',
? `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '郵箱',
? `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手機號碼',
? `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地址',
? `create_time` datetime(0) NULL DEFAULT NULL COMMENT '創建時間',
? `modified_time` datetime(0) NULL DEFAULT NULL COMMENT '修改時間',
? `create_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '創建人',
? `modified_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '修改人',
? `deleted` tinyint(0) UNSIGNED NULL DEFAULT 0 COMMENT '邏輯刪除標識(0、否 1、是)',
? PRIMARY KEY (`customer_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '客戶表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of customer
-- ----------------------------
INSERT INTO `customer` VALUES (1, '張強', '男', 18, '[email protected]', '12580', '北京', '2021-09-29 10:55:22', NULL, NULL, NULL, 0);
INSERT INTO `customer` VALUES (2, '王偉', '男', 25, '[email protected]', '177777', '南京', '2021-09-29 10:55:54', NULL, NULL, NULL, 0);
SET FOREIGN_KEY_CHECKS = 1;