                        課程
                    
                        /后端開發(fā)
                        
                            /Java
                        
                        /Springboot + ElasticSearch 構(gòu)建博客檢索系統(tǒng)

mysql的源數(shù)據(jù)

請(qǐng)問(wèn)有mysql數(shù)據(jù)庫(kù)里t_blog表的數(shù)據(jù)嗎？

上帝star3252970

2019-12-01

源自：Springboot + ElasticSearch 構(gòu)建博客檢索系統(tǒng) 4-2

關(guān)注問(wèn)題我要回答

835

操作

收起

2 回答

高行行
2019-12-08

CREATE DATABASE ems;

USE ems;

CREATE TABLE `t_blog` (? ??

? ?`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',? ??

? ?`title` varchar(60) DEFAULT NULL COMMENT '博客標(biāo)題',? ??

? ?`author` varchar(60) DEFAULT NULL COMMENT '博客作者',? ??

? ?`content` mediumtext COMMENT '博客內(nèi)容',? ??

? ?`create_time` datetime DEFAULT NULL COMMENT '創(chuàng)建時(shí)間',? ??

? ?`update_time` datetime DEFAULT NULL COMMENT '更新時(shí)間',? ??

? ?PRIMARY KEY (`id`)? ??

) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4

# 自己造的幾條數(shù)據(jù)

INSERT INTO `ems`.`t_blog`(`id`, `title`, `author`, `content`, `create_time`, `update_time`) VALUES (1, 'Springboot 為什么這', 'bywind', '沒(méi)錯(cuò) Springboot ', '2019-12-08 01:44:29', '2019-12-08 01:44:34');

INSERT INTO `ems`.`t_blog`(`id`, `title`, `author`, `content`, `create_time`, `update_time`) VALUES (3, 'Springboot 中 Redis', 'bywind', 'Spring Boot', '2019-12-08 01:44:29', '2019-12-08 01:44:29');

INSERT INTO `ems`.`t_blog`(`id`, `title`, `author`, `content`, `create_time`, `update_time`) VALUES (4, 'Springboot 中如何優(yōu)化', 'bywind', NULL, '2019-12-08 01:44:29', '2019-12-08 01:44:29');

INSERT INTO `ems`.`t_blog`(`id`, `title`, `author`, `content`, `create_time`, `update_time`) VALUES (5, 'Springboot 消息隊(duì)列', 'bywind', NULL, '2019-12-08 01:44:29', '2019-12-08 01:44:29');

INSERT INTO `ems`.`t_blog`(`id`, `title`, `author`, `content`, `create_time`, `update_time`) VALUES (6, 'Docker Compose + Springboot', 'bywind', NULL, '2019-12-08 01:44:29', '2019-12-08 01:44:29');