sql笔记

最新推荐文章于 2023-03-10 17:52:46 发布
最新推荐文章于 2023-03-10 17:52:46 发布
阅读量728 收藏
点赞数
文章标签： sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_36047517/article/details/107321553
版权

MySQL 分割笔记

说明 ：分割某个字段多值用，逗号隔开的情况
表如图：
在这里插入图片描述
创建语句：

CREATE TABLE `company` (
  `id` int(20) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `shareholder` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `company` VALUES ('1', '陕汽集团', '王总');
INSERT INTO `company` VALUES ('2', '淘宝', '刘志明,孙正义');

结果：
在这里插入图片描述
执行语句：

SELECT
	a.id,
	a. NAME,
	substring_index(
		substring_index(
			a.shareholder,
			',',
			b.help_topic_id + 1
		),
		',' ,- 1
	) AS shareholder
FROM
	company a
JOIN mysql.help_topic b ON b.help_topic_id < (
	length(a.shareholder) - length(
		REPLACE (a.shareholder, ',', '')
	) + 1
)

多条结果最终在封装成为一条结果：

例：
在这里插入图片描述
执行语句：

select apc.*,uid.*, ap.*,ac.* from (
	select GROUP_CONCAT(tname.name) as participants  from (
		select u.name from (
			SELECT  substring_index(substring_index(a.participants,',',b.help_topic_id + 1 ),',' ,- 1) AS participants 
				FROM iot_meeting a  JOIN mysql.help_topic b ON b.help_topic_id < (length(a.participants) - length( REPLACE (a.participants, ',', '')) + 1 ) 
        where  a.create_time  = '2020-05-19 10:03:13' and a.approve='已通过'
    ) t , iot_employee u 
				where t.participants = u.id ) tname) ap,( 
					select GROUP_CONCAT(tname.name) as checked  from ( 
							select iu.name  from (
								SELECT substring_index( substring_index(aa.checked,',', b.help_topic_id + 1),',' ,- 1) AS checked 
									FROM iot_meeting aa  JOIN mysql.help_topic b ON b.help_topic_id < ( length(aa.checked) - length( REPLACE (aa.checked, ',', '')) + 1 ) 
									where  aa.create_time  = '2020-05-19 10:03:13' and aa.approve='已通过'
							) tt , iot_employee iu where tt.checked = iu.id 
          ) tname 
			) ac ,
 ( 
	select mr.`name`,mr.room,m.company_id,m.user_name,m.`name` mname,m.start_time,m.end_time,m.`host`,m.approve,m.create_time createTime,m.organizers,m.remarks  
	from  iot_meeting_room mr RIGHT JOIN iot_meeting m ON mr.id = m.meeting_room_id  where m.create_time = '2020-05-19 10:03:13' and m.approve='已通过') apc ,

( select iou.username user_id 
	from iot_meeting iotm ,iot_user iou where iotm.user_id = iou.id and iotm.create_time = '2020-05-19 10:03:13' and iotm.approve='已通过') uid

创建SQL语句
iot_meeting

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 80020
Source Host           : localhost:3306
Source Database       : meeting

Target Server Type    : MYSQL
Target Server Version : 80020
File Encoding         : 65001

Date: 2020-07-13 17:59:02
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `iot_meeting`
-- ----------------------------
DROP TABLE IF EXISTS `iot_meeting`;
CREATE TABLE `iot_meeting` (
  `id` varchar(64) NOT NULL,
  `meeting_room_id` varchar(64) NOT NULL,
  `company_id` varchar(64) NOT NULL,
  `user_id` varchar(64) NOT NULL COMMENT '创建人id',
  `user_name` varchar(64) NOT NULL,
  `name` varchar(64) NOT NULL COMMENT '会议名称',
  `start_time` varchar(64) NOT NULL COMMENT '会议开始时间',
  `end_time` varchar(64) NOT NULL COMMENT '会议结束时间',
  `host` varchar(64) DEFAULT NULL COMMENT '主持人',
  `organizers` varchar(64) DEFAULT NULL COMMENT '组织人',
  `participants` text COMMENT '参会人员',
  `remarks` varchar(1024) DEFAULT NULL COMMENT '备注',
  `approve` varchar(64) NOT NULL COMMENT '审批状态',
  `checked` text COMMENT '已签到人员',
  `nochecked` text COMMENT '未签到人员',
  `path` varchar(1024) DEFAULT NULL COMMENT '二维码路径',
  `create_by` varchar(64) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(64) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of iot_meeting
-- ----------------------------
INSERT INTO `iot_meeting` VALUES ('123456', '2142916388f233678e15bd8af07e3f6d', 'hongzhe', 'cadca0a39cb84758eefdeb9bcec58fb9', 'master', 'TEST', '2020/07/03 10:10', '2020/06/30 18:00', '1', '1', 'f991c416622e32cf18ce710a83ba2268', '1', '已通过', null, null, 'files/20200628/code_1593333622813.png', 'master', '2020-06-11 09:30:09', 'master', '2020-06-28 16:40:23');
INSERT INTO `iot_meeting` VALUES ('2746a8654da78f8ab37b157790f4be01', '2142916388f233678e15bd8af07e3f6d', 'hongzhe', 'cadca0a39cb84758eefdeb9bcec58fb9', 'master', 'test', '2020/01/20 00:00', '2020/01/20 00:02', '1', '1', '38f46772150a8723c41aed56f62b3528,63a9b3f882c67ea2fd42830c77dc806f,7a86bd8f5622be926500be97c3642c8f,8fd98010cc69b02b9d99a265b6b81de8,d80260d9f28dfb26ea83648082de8b76,db0f4ff95464248ca6bea6658fa366c7,74a27e7c00261cb56e1fde33f3c5c90b,13a13ee8b190494f56031d25d18032b8,15bda57eba9a36a9cf5fb3e727b9c6f2,2ab324cb5d34d389e4f95dfe2b76abc0,cb0cb8486e0baffca295c23eb36e984a,291d4b9eb531562b3f367aa9dd5ddfa6,425b4d75a3a5b430d83f5b40e62a2939,47288c0b31dbb601c4e74b141c7422ff,d3574999b88e8a04b782f2f2679f3614,4d3dfc7e51e5d7a0561c41341c4b3c94,f134b72b0dc103f371e9a615c94a1cf2,5e855e5a759f22340871e3a689583089,fbea119574a8e17fe50aa0e809a63065,6145912c83132b639e931f05538e29a2,6b4232c62d14e6c9e1c4d51de763d7b2,a097aac2e0dee0c8bd60d764b08f9802,d62bf2c6803bbf389aa146d9fe4ef888,0a40d692cdf733f249e17a14866559f5,14176338911970b477ebe1c9d1f9be78,2f60cb8a7065676751e2893d1b44f550,47e1f3a59a4ddc8dca792558bb4038de,93a2adb1fb8f474dc0d1d4a015bcc017,9cafa7da4f82016adcd41652535759ef,a73abe7ced7d60245dd10675bfd28b4a,b25a9f917a58deb061ac2f86f65d4326,b57b3a0eb393c3cd94f737c476413156,c7cdb56d2287c1fb42daf0f5c49cd4c4,d13a86e8d5bd24c98160ddc66ff96e60,d53bffaec7cdeea5201dfff031d04e14,ecc40536bfaa55a07725d25ac7c87192,ee79fd0a17ceb4ad223f4e77ed6cfe6c,f3b3cc0dcac3eaddf9472fbb857ce58e,f991c416622e32cf18ce710a83ba2268', '1', '已通过', '74a27e7c00261cb56e1fde33f3c5c90b,7a86bd8f5622be926500be97c3642c8f', null, 'files/20200120/code_1579510955276.png', 'master', '2020-01-20 17:02:32', 'jeecg', '2020-03-06 17:23:03');
INSERT INTO `iot_meeting` VALUES ('411409fbc48b488eaccbeab2f126bdf0', '2142916388f233678e15bd8af07e3f6d', 'hongzhe', 'ce6702c4778a29026241bb6de54c1275', 'normal', 'aaaa', '2020/05/19 00:00', '2020/05/19 00:01', 'aa', 'aa', '7a86bd8f5622be926500be97c3642c8f,8fd98010cc69b02b9d99a265b6b81de8', 'aaaaaa', '已通过', '7a86bd8f5622be926500be97c3642c8f', null, 'files/20200519/code_1589854172068.png', 'normal', '2020-05-19 10:03:13', 'jeecg', '2020-05-19 10:11:16');
INSERT INTO `iot_meeting` VALUES ('49090db521d3f846fe5181ce8801100b', '64047c0365b7ea8ba176c6704c4e9be4', 'hongzhe', 'ce6702c4778a29026241bb6de54c1275', 'normal', '3', '2020/06/30 00:00', '2020/06/30 00:01', '行政部', null, null, null, '已通过', null, null, null, 'normal', '2020-06-30 08:46:16', 'normal', '2020-06-30 08:46:24');
INSERT INTO `iot_meeting` VALUES ('4c88e778214c9a0347340411af330f8e', '2142916388f233678e15bd8af07e3f6d', 'hongzhe', 'cadca0a39cb84758eefdeb9bcec58fb9', 'master', '111111111111111111111', '2020/03/05 00:00', '2020/06/05 00:01', 'qwe', 'aaa', '7a86bd8f5622be926500be97c3642c8f,8fd98010cc69b02b9d99a265b6b81de8,d80260d9f28dfb26ea83648082de8b76,74a27e7c00261cb56e1fde33f3c5c90b', null, '已通过', '7a86bd8f5622be926500be97c3642c8f,74a27e7c00261cb56e1fde33f3c5c90b', null, 'files/20200305/code_1583401133930.png', 'master', '2020-06-03 17:38:21', 'jeecg', '2020-03-06 18:19:47');
INSERT INTO `iot_meeting` VALUES ('627dc1aa8abbc4dc0920e8ab64e03755', '2142916388f233678e15bd8af07e3f6d', 'hongzhe', 'cadca0a39cb84758eefdeb9bcec58fb9', 'master', '啊啊啊', '2020/03/06 00:00', '2020/03/06 00:02', '111', '111', '38f46772150a8723c41aed56f62b3528,63a9b3f882c67ea2fd42830c77dc806f,7a86bd8f5622be926500be97c3642c8f', '222', '已通过', '7a86bd8f5622be926500be97c3642c8f', null, 'files/20200306/code_1583489902528.png', 'master', '2020-03-06 18:18:05', 'jeecg', '2020-03-10 15:54:36');
INSERT INTO `iot_meeting` VALUES ('6fdc7b32f62ff1fbe995932c4525853f', '2142916388f233678e15bd8af07e3f6d', 'hongzhe', 'cadca0a39cb84758eefdeb9bcec58fb9', 'master', '测试', '2020/05/19 08:00', '2020/05/19 09:00', '测试', '测试', '7a86bd8f5622be926500be97c3642c8f', '测试', '已通过', '7a86bd8f5622be926500be97c3642c8f', null, 'files/20200519/code_1589848771091.png', 'master', '2020-05-19 08:39:05', 'jeecg', '2020-05-19 08:41:47');
INSERT INTO `iot_meeting` VALUES ('7cf134ac96e47fa18b8b13be421922d9', '2142916388f233678e15bd8af07e3f6d', 'hongzhe', 'cadca0a39cb84758eefdeb9bcec58fb9', 'master', '1212', '2020/03/06 00:00', '2020/03/06 00:01', '112', '122', '13a13ee8b190494f56031d25d18032b8,15bda57eba9a36a9cf5fb3e727b9c6f2,2ab324cb5d34d389e4f95dfe2b76abc0,cb0cb8486e0baffca295c23eb36e984a,291d4b9eb531562b3f367aa9dd5ddfa6,38f46772150a8723c41aed56f62b3528,63a9b3f882c67ea2fd42830c77dc806f,7a86bd8f5622be926500be97c3642c8f,8fd98010cc69b02b9d99a265b6b81de8,d80260d9f28dfb26ea83648082de8b76,db0f4ff95464248ca6bea6658fa366c7,425b4d75a3a5b430d83f5b40e62a2939,47288c0b31dbb601c4e74b141c7422ff,d3574999b88e8a04b782f2f2679f3614,4d3dfc7e51e5d7a0561c41341c4b3c94,f134b72b0dc103f371e9a615c94a1cf2,5e855e5a759f22340871e3a689583089,fbea119574a8e17fe50aa0e809a63065,6145912c83132b639e931f05538e29a2,6b4232c62d14e6c9e1c4d51de763d7b2,a097aac2e0dee0c8bd60d764b08f9802,d62bf2c6803bbf389aa146d9fe4ef888,0a40d692cdf733f249e17a14866559f5,14176338911970b477ebe1c9d1f9be78,2f60cb8a7065676751e2893d1b44f550,47e1f3a59a4ddc8dca792558bb4038de,74a27e7c00261cb56e1fde33f3c5c90b,93a2adb1fb8f474dc0d1d4a015bcc017,9cafa7da4f82016adcd41652535759ef,a73abe7ced7d60245dd10675bfd28b4a,b25a9f917a58deb061ac2f86f65d4326,b57b3a0eb393c3cd94f737c476413156,c7cdb56d2287c1fb42daf0f5c49cd4c4,d13a86e8d5bd24c98160ddc66ff96e60,d53bffaec7cdeea5201dfff031d04e14,ecc40536bfaa55a07725d25ac7c87192,ee79fd0a17ceb4ad223f4e77ed6cfe6c,f3b3cc0dcac3eaddf9472fbb857ce58e,f991c416622e32cf18ce710a83ba2268', '1', '已通过', '7a86bd8f5622be926500be97c3642c8f', null, 'files/20200306/code_1583485127945.png', 'master', '2020-03-06 16:58:34', 'jeecg', '2020-03-06 17:16:23');
INSERT INTO `iot_meeting` VALUES ('7f2af764fcbc25b8e9fbb06e7d1f056f', '2142916388f233678e15bd8af07e3f6d', 'hongzhe', 'cadca0a39cb84758eefdeb9bcec58fb9', 'master', '111111', '2020/03/06 00:00', '2020/03/06 00:01', null, null, '7a86bd8f5622be926500be97c3642c8f,8fd98010cc69b02b9d99a265b6b81de8', null, '已通过', null, null, 'files/20200306/code_1583486498062.png', 'master', '2020-03-06 17:21:26', 'master', '2020-03-06 17:21:38');

iot_employee

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 80020
Source Host           : localhost:3306
Source Database       : meeting

Target Server Type    : MYSQL
Target Server Version : 80020
File Encoding         : 65001

Date: 2020-07-13 18:04:32
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `iot_employee`
-- ----------------------------
DROP TABLE IF EXISTS `iot_employee`;
CREATE TABLE `iot_employee` (
  `id` varchar(64) NOT NULL COMMENT 'id',
  `company_id` varchar(64) NOT NULL COMMENT '公司编号',
  `name` varchar(128) NOT NULL COMMENT '姓名',
  `email` varchar(128) NOT NULL COMMENT '邮箱',
  `gender` varchar(32) DEFAULT NULL COMMENT '性别',
  `phone_number` varchar(32) DEFAULT NULL COMMENT '电话',
  `department` varchar(128) DEFAULT NULL COMMENT '部门',
  `duties` varchar(64) DEFAULT NULL COMMENT '职位',
  `remarks` varchar(512) DEFAULT NULL COMMENT '备注',
  `user_id` varchar(64) DEFAULT NULL COMMENT '账号id',
  `create_by` varchar(128) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(128) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of iot_employee
-- ----------------------------
INSERT INTO `iot_employee` VALUES ('0a40d692cdf733f249e17a14866559f5', 'hongzhe', '陈柏佳', 'chenbaijia@hongzhe.com.cn', null, null, null, null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('13a13ee8b190494f56031d25d18032b8', 'hongzhe', '何俊', 'hejun@hongzhe.com.cn', '男', '13823318577', '西安分公司', null, null, null, 'master', '2019-10-23 14:41:58', 'master', '2020-03-06 18:17:25');
INSERT INTO `iot_employee` VALUES ('14176338911970b477ebe1c9d1f9be78', 'hongzhe', '罗宏兴', 'luohongxing@hongzhe.com.cn', null, null, null, null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('15bda57eba9a36a9cf5fb3e727b9c6f2', 'hongzhe', '邱盛超', 'qsc@hongzhe.com.cn', '男', '15986767976', 'A/V产品事业部', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('2', 'saisibo', '4', '4', '4', '4', '4', '4', '4', null, 'admin', null, null, null);
INSERT INTO `iot_employee` VALUES ('291d4b9eb531562b3f367aa9dd5ddfa6', 'hongzhe', '罗伟平', 'lwp@hongzhe.com.cn', '男', '13828802965', '工程与客服中心', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('2ab324cb5d34d389e4f95dfe2b76abc0', 'hongzhe', '陈晓俊', 'cxj@hongzhe.com.cn', '男', '13923802848', 'A/V产品事业部', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('2f60cb8a7065676751e2893d1b44f550', 'hongzhe', '冯玉英', 'fyy@hongzhe.com.cn', null, null, null, null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('38f46772150a8723c41aed56f62b3528', 'hongzhe', '李强', 'liqiang@hongzhe.com.cn', '男', '15899881683', '研发部', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('425b4d75a3a5b430d83f5b40e62a2939', 'hongzhe', '樊陆平', 'flp@hongzhe.com.cn', '男', '13902481945', '总经办', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('47288c0b31dbb601c4e74b141c7422ff', 'hongzhe', '陈谦', 'business@hongzhe.com.cn', '女', '15927228965', '总经办', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('47e1f3a59a4ddc8dca792558bb4038de', 'hongzhe', '赵亚林', 'zhaoyalin@hongzhe.com.cn', null, null, null, null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('4d3dfc7e51e5d7a0561c41341c4b3c94', 'hongzhe', '韩文萍', 'hanwenping@hongzhe.com.cn', '女', '18681800617', '设计中心', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('5e855e5a759f22340871e3a689583089', 'hongzhe', '韦文平', 'weiwenping@hongzhe.com.cn', '女', '13510616403', '财务部', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('6145912c83132b639e931f05538e29a2', 'hongzhe', '黄方亭', 'hft@hongzhe.com.cn', '男', '13902315946', '系统集成事业部', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('63a9b3f882c67ea2fd42830c77dc806f', 'hongzhe', '孟超宇', 'mengchaoyu@hongzhe.com.cn', '男', '13923803245', '研发部', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('6b4232c62d14e6c9e1c4d51de763d7b2', 'hongzhe', '胡素玲', 'av-tech@hongzhe.com.cn', '女', '13691679160', '行政人事部', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('74a27e7c00261cb56e1fde33f3c5c90b', 'hongzhe', '柯宏', 'kehong@hongzhe.com.cn', null, null, null, null, null, 'd338db8edc511f8536436872d6277a82', 'master', '2019-10-23 14:41:58', 'master', '2020-03-05 15:57:38');
INSERT INTO `iot_employee` VALUES ('7a86bd8f5622be926500be97c3642c8f', 'hongzhe', '尤航航', '18710940776@163.com', '男', '18710940776', '研发部', '职员', '无', 'ddbdf91e9cb333c60fbf72bc55ddd066', 'master', '2019-10-23 14:41:58', 'master', '2020-06-30 08:45:43');
INSERT INTO `iot_employee` VALUES ('87c3e4b857e11bd31c49a9b4a8e18147', 'hongzhe', '李雷', 'kehong@hongzhe.com.cn', null, null, null, null, null, null, 'master', '2020-05-27 09:48:28', null, null);
INSERT INTO `iot_employee` VALUES ('8fd98010cc69b02b9d99a265b6b81de8', 'hongzhe', '樊铭哲', 'fanmingzhe@hongzhe.com.cn', '男', '13823311390', '研发部', null, null, 'ce6702c4778a29026241bb6de54c1275', 'master', '2019-10-23 14:41:58', 'master', '2020-03-06 17:21:01');
INSERT INTO `iot_employee` VALUES ('93a2adb1fb8f474dc0d1d4a015bcc017', 'hongzhe', '徐博', 'xubo@hongzhe.com.cn', null, null, null, null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('a097aac2e0dee0c8bd60d764b08f9802', 'hongzhe', '赵亚林', 'zhaoyalin@hongzhe.com.cn', '女', '13615966137', '行政人事部', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('a73abe7ced7d60245dd10675bfd28b4a', 'hongzhe', '成雄杰', 'chengxiongjie@hongzhe.com.cn', null, null, null, null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('b57b3a0eb393c3cd94f737c476413156', 'hongzhe', '孟娜', 'mengna@hongzhe.com.cn', null, null, null, null, null, '2503adc7b65a0ca3ec532179d445a2e2', 'master', '2019-10-23 14:41:58', 'master', '2020-06-28 16:27:16');
INSERT INTO `iot_employee` VALUES ('c7cdb56d2287c1fb42daf0f5c49cd4c4', 'hongzhe', '何丹文', 'hedanwen@hongzhe.com.cn', null, null, null, null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('cb0cb8486e0baffca295c23eb36e984a', 'hongzhe', '罗志杰', 'luozhijie@hongzhe.com.cn', '男', '13825236022', 'A/V产品事业部', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('d13a86e8d5bd24c98160ddc66ff96e60', 'hongzhe', '黄小欣', 'huangxiaoxin@hongzhe.com.cn', null, null, null, null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('d3574999b88e8a04b782f2f2679f3614', 'hongzhe', '罗勤英', 'lqy@hongzhe.com.cn', '女', '13600439444', '总经办', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('d53bffaec7cdeea5201dfff031d04e14', 'hongzhe', '孟超宇', 'mengchaoyu@hongzhe.com.cn', null, null, null, null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('d62bf2c6803bbf389aa146d9fe4ef888', 'hongzhe', '黎生全', 'lsq@hongzhe.com.cn', '男', '13751087020', 'Samsung显示产品事业部', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('d80260d9f28dfb26ea83648082de8b76', 'hongzhe', '赵晨', 'zhaochen@hongzhe.com.cn', '女', '18620375277', '研发部', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('db0f4ff95464248ca6bea6658fa366c7', 'hongzhe', '孟晓波', 'mxb@hongzhe.com.cn', '男', '18700952650', '研发部', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('ecc40536bfaa55a07725d25ac7c87192', 'hongzhe', '刘楚华', 'lch@hongzhe.com.cn', null, null, null, null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('ee79fd0a17ceb4ad223f4e77ed6cfe6c', 'hongzhe', '樊铭哲', 'fanmingzhe@hongzhe.com.cn', null, null, null, null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('f134b72b0dc103f371e9a615c94a1cf2', 'hongzhe', '袁晨光', 'ycg@hongzhe.com.cn', '男', '13823324578', '设计中心', null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('f3b3cc0dcac3eaddf9472fbb857ce58e', 'hongzhe', '杨柳养', 'yangliuyang@hongzhe.com.cn', null, null, null, null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('f991c416622e32cf18ce710a83ba2268', 'hongzhe', '杨韬', '2208753088@qq.com', null, '15875597225', null, null, null, null, 'master', '2019-10-23 14:41:58', null, null);
INSERT INTO `iot_employee` VALUES ('fbea119574a8e17fe50aa0e809a63065', 'hongzhe', '吴艳菊', 'wuyanju@hongzhe.com.cn', '女', '19874316022', '财务部', null, null, null, 'master', '2019-10-23 14:41:58', null, null);

iot_meeting_room

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 80020
Source Host           : localhost:3306
Source Database       : meeting

Target Server Type    : MYSQL
Target Server Version : 80020
File Encoding         : 65001

Date: 2020-07-13 18:05:54
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `iot_meeting_room`
-- ----------------------------
DROP TABLE IF EXISTS `iot_meeting_room`;
CREATE TABLE `iot_meeting_room` (
  `id` varchar(64) NOT NULL,
  `company_id` varchar(64) NOT NULL,
  `name` varchar(128) NOT NULL COMMENT '会议室名称',
  `room` varchar(128) DEFAULT NULL COMMENT '房间名称',
  `people` int NOT NULL COMMENT '可容纳人数',
  `phone_number` varchar(32) DEFAULT NULL COMMENT '电话',
  `remarks` varchar(1024) DEFAULT NULL COMMENT '备注',
  `create_by` varchar(32) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of iot_meeting_room
-- ----------------------------
INSERT INTO `iot_meeting_room` VALUES ('2', 'saisibo', '4', '4', '4', '4', '4', null, null, null, null);
INSERT INTO `iot_meeting_room` VALUES ('2142916388f233678e15bd8af07e3f6d', 'hongzhe', '2号会议室', '102', '4', '120', '22', 'admin', '2019-09-11 11:20:18', 'admin', '2019-09-12 17:38:02');
INSERT INTO `iot_meeting_room` VALUES ('64047c0365b7ea8ba176c6704c4e9be4', 'hongzhe', '3号会议室', '103', '10', '110', '11', 'admin', '2019-09-12 17:37:47', 'admin', '2019-09-12 17:37:56');
INSERT INTO `iot_meeting_room` VALUES ('6ea8e3d89324b75c1e2c478612e4408c', 'hongzhe', '测试会议室', '102中厅', '6', '11', null, 'admin', '2019-09-19 09:00:31', 'master', '2020-06-28 11:55:27');
INSERT INTO `iot_meeting_room` VALUES ('b2b194fcba6900556ee1cb386c185cf9', 'hongzhe', '无间道剧本续集', '103大厅', '300', '13311115555', '续集剧本讨论', 'master', '2020-06-28 11:56:59', null, null);
INSERT INTO `iot_meeting_room` VALUES ('ffa1c754e58cd3bf9e66547e325bc883', 'yijin', '1会议室', null, '1', null, null, 'master', '2019-10-31 10:39:30', null, null);
辉_哥
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Mysql 进阶
weixin_45856713的博客
11-10 647
Mysql 进阶1：基础查询title: 进阶1：基础查询 date: 2020-11-09 23:54:40 tags: -Java -MySql categories: -Java -Mysql进阶1：基础查询day1 测试 title: 进阶1：基础查询 date: 2020-11-09 23:54:40 tags: -Java -MySql categories: -Java -Mysql sql文件 /* Navicat Premium Data Transfer Source Serve
SQL笔记整理
07-17
SQL：structured query language 创建数据库：create database student (数据库名) 创建数据库表： create table student( userid int not null primary key, lastname varchar(255), firstname varchar(255))（创建...
navicate导入sql文件失败
最新发布
budaoweng0609的博客
03-10 2600
navicate导入sql文件报错问题
springboot整合spring security
txyllyyj的博客
11-18 815
导入sql /* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 80011 Source Host : localhost:3306 Source Schema : securitydemo Target Server Type : MySQL Targe
001云E办项目之创建项目
热爱编写程序的药学在读书
10-29 2564
这文章后续会陆陆续续的退出更多，有如下的一些建议： 如果你在想跟着一个项目练习，请认认真真看完没一点 你可以收获很多知识 说不定以后就是你去公司创建项目的流程 一、创建项目 1、创建一个SpringBoot项目 创建yeb为一个父项目，里面的除了pom.xml文件不删，其他的都有可以干掉 创建yeb-server为子项目，这个里面什么都不能删，这个是创建Maven项目 2、看父项目依赖 <?xml version="1.0" encoding="UTF-8"?> <project
mysql创表的工种_mysql测试数据库employees一些sql语句
weixin_34345695的博客
01-30 546
一套SQL笔试题1、查找整个职员表的所有内容。select *from employees2、查看雇员名字(last_name)。select last_namefrom employees3、查看雇员编号、名字和工种。select last_name，job_id，employee_idfrom employees4、显示所有雇员的姓名、工资并将DEPARTMENT_ID显示为(Departme...
SQL笔记下载
06-12
除了这些基础操作，SQL笔记可能还会涉及更复杂的查询技术，比如联接（JOIN）、子查询、视图（VIEW）的创建和使用，以及事务处理（TRANSACTION）等。联接允许你从多个表中合并数据，子查询可以在主查询内部执行查询，...
sql笔记.md
05-23
sql笔记.md
20170909学习sql笔记
04-30
标题“20170909学习sql笔记”表明这是一个关于SQL学习的资料，可能包含了一天的学习记录或者一个教程的集合。SQL，全称Structured Query Language，是用于管理和处理关系数据库的标准语言。这个标题暗示我们将探讨...
sql笔记sql笔记sql笔记sql笔记sql笔记sql笔记
05-25
sql笔记sql笔记sql笔记sql笔记sql笔记sql笔记
11.zipSource Server : changgou Source Server Type : MySQL Source Se
11-14
Source Server : changgou Source Server Type : MySQL Source Server Version : 50726 Source Host : 192.168.159.134:3306 Source Schema : changgou_all Target Server Type : MySQL Target Server Version : 50726 File Encoding : 65001
搭建我的第一个MyBatis项目
qq_46476615的博客
03-22 324
安装JDK并配置环境变量 https://www.runoob.com/w3cnote/windows10-java-setup.html 安装eclipse 建议使用解压版 安装MySQL数据库和Navicat for MySQL MySQL数据库建议安装5版本的 配置Maven 1、新建项目 直接新建maven项目即可 2、添加jar：pom.xml <?xml version="1....
JAVA学习,数据库建库文件
我的博客
07-05 412
db_lezijie_note.sql /* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50505 Source Host : localhost:3306 Source Database : db_lezijie_note Target Server Type : MYSQL Target Server Version :
SpringBoot整合MyBatis框架（学习笔记六）
Li_RC_XCN的博客
07-31 138
MyBatis 最强大的特性之一就是它的动态语句功能。如果您以前有使用JDBC或者类似框架的经历，您就会明白把SQL语句条件连接在一起是多么的痛苦，要确保不能忘记空格或者不要在columns列后面省略一个逗号等。动态语句能够完全解决掉这些痛苦。...
springboot+vue3+ts实现一个点赞功能
crazy1013的博客
11-22 1857
前端：vite+vue3+ts+elementplus+less后端：springboot2.7.5+mybatisplus后端：引入pom依赖运行sql项目结构 yml配置entity下的三个实体类Article： GiveALike：User：mapperArticleMapper：GiveALikeMapper：UserMapper：controller前端：相关依赖目录结构 main.ts页面App.vue页面 路由router 登录页面login home页面 上述代码如有问题，欢迎提出来，博主看
2020-09-03
Eding_的博客
09-03 724
城市三级 2019（台湾、澳门、香港可能不太准确） /* Navicat Premium Data Transfer Source Server : localhost_3306 Source Server Type : MySQL Source Server Version : 80019 Source Host : localhost:3306 Source Schema : test Target Server Type : MySQL
Mybatis学习之数据库
ONLY1024的博客
08-06 534
运行sql语句创建数据库 /* Navicat MySQL Data Transfer Source Server : admin Source Server Type : MySQL Source Server Version : 80023 Source Host : localhost:3306 Source Schema : mybatis Target Server Type : MySQL Target Server Version
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值