csdnxyy的博客

AND INFO LIKE ‘%处于打开状态的表名%’① 找到阻塞flush tables的慢查询。② 找到flush tables慢查询。1 找到正处于open状态的表。杀掉2 步骤中找到的两个慢查询。2 找到引发故障的慢查询。

Mysql自增主键设置

mysq数据库查询

INSERT INTO oper_result (ASSEM_ID,STATION_ID,PASS_FLAG,OPER_USER,UPDATE_TIME,LINE_ID,ORDER_ID)SELECT ASSEM_ID, ‘302A’, ‘1’, ‘admin’, CREATE_TIME AS UPDATE_TIME, ‘04’, ‘20220330001’ FROM assembly_info WHERE ORDER_ID = ‘20220330001’...

1.新建存储过程：DELIMITER $$USE `rntec`$$DROP PROCEDURE IF EXISTS `copy_data_1_day`$$CREATE DEFINER=`root`@`%` PROCEDURE `copy_data_1_day`()BEGINDECLARE v_date_0 VARCHAR(30);-- 获取6个月前日期 SELECT DATE_FORMAT(DATE_SUB(DATE(NOW()),INTERVAL 6 MONTH),'%...

UPDATE info_history SET CREATE_TIME =DATE_SUB(CREATE_TIME,INTERVAL 2 SECOND)

UPDATE log_history a ,(SELECT * FROM detail_history WHERE REMARK IS NOT NULL ) b SET a.REMARK=b.REMARK WHERE a.KEY_ID=b.RELA_LOG_ID

创建定时事件：设置5秒往test表添加一次数据，添加的数值为一个设置的随机数；CREATE EVENT IF NOT EXISTS event_testON SCHEDULE EVERY 5 SECOND ON COMPLETION PRESERVEDO INSERT INTO test (NAME, VALUE, CREATE_TIME ) VALUES ('temper', TRUNCATE((20 + RAND() * 10),2) ,...

写法： replace函数update 表名 set 字段=replace(字段，‘替换的部分’，‘替换后的字符串’)；

//主键新增时使用<insert id="saveParam" parameterType="com.making.vo.param.CraftParamVO"> <selectKey keyProperty="paramId" resultType="String" order="BEFORE"> select IFNULL(max(CONV...

serviceImpl中： if (StringTool.isNotEmpty(elementID)){ String paramList = ""; List list = carftparamdao.getExistParamList(elementID); for(int i=0;i<list.size();i++){ paramList+=list....

<insert id="saveParam" parameterType="com.xxx.param.ParamVO"> <selectKey keyProperty="paramId" resultType="String" order="BEFORE"> select IFNULL(max(CONVERT(PARAM_ID, UNSIGNED INTEGER)+1),'100') from PARAM </selectKey> .

UPDATE student s1 JOIN student s2 ON s1.ID='xxxx' AND s2.ID='xxxx' SET s1.NAME=s2.NAME,s2.NAME=s1.NAME