mysql测试数据图表_mysql测试数据表

1.截取至后盾人

用于mysql数据测试

请在navicat中执行一下命令生成测试数据表

/*

Navicat Premium Data Transfer

Source Server : 我的本地连接

Source Server Type : MySQL

Source Server Version : 50726

Source Host : localhost:3306

Source Schema : laravel

Target Server Type : MySQL

Target Server Version : 50726

File Encoding : 65001

Date: 13/01/2021 16:52:03

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------

-- Table structure for article

-- ----------------------------

DROP TABLE IF EXISTS `article`;

CREATE TABLE `article` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

`publish_time` datetime(0) NULL DEFAULT NULL,

`status` tinyint(4) NULL DEFAULT 1,

`click` int(11) NOT NULL DEFAULT 0,

`flag` set('推荐','置顶','热门','图文') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

`stu_id` int(11) NOT NULL,

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章表' ROW_FORMAT = Dynamic;

-- ----------------------------

-- Records of article

-- ----------------------------

INSERT INTO `article` VALUES (1, 'PHP很好学习，功能强大', '2019-06-12 18:00:00', 1, 18, NULL, 1);

INSERT INTO `article` VALUES (2, 'Mysql系统课程正在更新', '2019-07-12 18:00:00', 1, 18, NULL, 3);

INSERT INTO `article` VALUES (3, '后盾人在线学习编程', NULL, 1, 100, '推荐', 5);

INSERT INTO `article` VALUES (4, '文档库在doc.houdunren.com', NULL, 1, 100, '推荐,置顶,图文', 2);

-- ----------------------------

--