![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
笔记
营山第一型男
有朋自远方来,不亦乐乎
展开
-
MySQL触发器配合游标实现数据同步处理
DELIMITER $$USE `beifen`$$DROP TRIGGER /*!50032 IF EXISTS */ `monitor_userdepartmentchange_test`$$CREATE /*!50017 DEFINER = 'root'@'%' */ TRIGGER `monitor_userdepartmentchange_test` AFTER UPDATE ON `tsm_user` FOR EACH ROW BEGIN #用户新部门I.原创 2021-08-20 17:36:37 · 129 阅读 · 0 评论 -
MySQL查询对相同字段分组进行排号
SELECT s.id,s.image_path,s.attach_title,s.attach_required,s.`task_name`,s.originalFilename original, @r:= CASE WHEN @asset_code=s.asset_code THEN @r+1 ELSE 1 END AS rowNum, @asset_code:=s.asset_code AS asset_code FROM (SELECT i.*, f.attach_title...原创 2021-08-19 15:58:02 · 915 阅读 · 0 评论 -
Linux rpm方式安装社区版mysql-5.7.21详细教程
1、执行命令:rpm-qa|grep-imysql 查看是否已安装过mysql2、执行命令:rpm -qa |grep -i mariadb 查看原创 2021-06-15 16:27:36 · 592 阅读 · 0 评论 -
Linux 解压安装jdk1.8.0_161详细教程
1、原创 2021-06-15 14:26:39 · 2785 阅读 · 0 评论 -
用eclipse+tomcat7+jdk1.7+maven3.5.0搭建SSM开发环境
1.spring-mybatis.xml<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="原创 2018-06-01 23:27:41 · 1098 阅读 · 0 评论 -
用eclipse+tomcat7+jdk1.7+maven3.5.0搭建SSH开发环境
1.applicationContext.xml<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="原创 2018-06-01 23:55:55 · 213 阅读 · 0 评论