課程
/后端開(kāi)發(fā)
/Java
/MyBatis-Plus + SpringBoot實(shí)現(xiàn)簡(jiǎn)單權(quán)限管理
老師可以把帶有數(shù)據(jù)的sql發(fā)一下嗎？
2021-09-06
源自：MyBatis-Plus + SpringBoot實(shí)現(xiàn)簡(jiǎn)單權(quán)限管理 6-3
正在回答
抱歉，這個(gè)不能發(fā)
老猿
自己造數(shù)據(jù)多好。
這是我造的數(shù)據(jù)
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 '真實(shí)姓名',
? `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 '手機(jī)號(hào)碼',
? `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地址',
? `create_time` datetime(0) NULL DEFAULT NULL COMMENT '創(chuàng)建時(shí)間',
? `modified_time` datetime(0) NULL DEFAULT NULL COMMENT '修改時(shí)間',
? `create_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '創(chuàng)建人',
? `modified_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '修改人',
? `deleted` tinyint(0) UNSIGNED NULL DEFAULT 0 COMMENT '邏輯刪除標(biāo)識(shí)(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, '張強(qiáng)', '男', 18, '1@163.com', '12580', '北京', '2021-09-29 10:55:22', NULL, NULL, NULL, 0);
INSERT INTO `customer` VALUES (2, '王偉', '男', 25, '1@163.com', '177777', '南京', '2021-09-29 10:55:54', NULL, NULL, NULL, 0);
SET FOREIGN_KEY_CHECKS = 1;
舉報(bào)
通過(guò)實(shí)戰(zhàn)項(xiàng)目掌握MyBatis-Plus應(yīng)用！
1 回答數(shù)據(jù)庫(kù)沒(méi)有刪除
2 回答新添加數(shù)據(jù)有空數(shù)據(jù)字段時(shí)，無(wú)法查詢出來(lái)
1 回答數(shù)據(jù)直接添加了兩條數(shù)據(jù)？
2 回答sql問(wèn)題
2 回答數(shù)據(jù)庫(kù)腳本
Copyright ? 2025 imooc.com All Rights Reserved | 京ICP備12003892號(hào)-11 京公網(wǎng)安備11010802030151號(hào)
購(gòu)課補(bǔ)貼聯(lián)系客服咨詢優(yōu)惠詳情
慕課網(wǎng)APP您的移動(dòng)學(xué)習(xí)伙伴
掃描二維碼關(guān)注慕課網(wǎng)微信公眾號(hào)
2021-10-04
抱歉，這個(gè)不能發(fā)
2022-02-06
自己造數(shù)據(jù)多好。
這是我造的數(shù)據(jù)
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 '真實(shí)姓名',
? `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 '手機(jī)號(hào)碼',
? `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地址',
? `create_time` datetime(0) NULL DEFAULT NULL COMMENT '創(chuàng)建時(shí)間',
? `modified_time` datetime(0) NULL DEFAULT NULL COMMENT '修改時(shí)間',
? `create_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '創(chuàng)建人',
? `modified_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '修改人',
? `deleted` tinyint(0) UNSIGNED NULL DEFAULT 0 COMMENT '邏輯刪除標(biāo)識(shí)(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, '張強(qiáng)', '男', 18, '1@163.com', '12580', '北京', '2021-09-29 10:55:22', NULL, NULL, NULL, 0);
INSERT INTO `customer` VALUES (2, '王偉', '男', 25, '1@163.com', '177777', '南京', '2021-09-29 10:55:54', NULL, NULL, NULL, 0);
SET FOREIGN_KEY_CHECKS = 1;