- 博客(7)
- 问答 (4)
- 收藏
- 关注
转载 MySQL根据id查询当前节点的层级
SELECT COUNT(*) FROM ( SELECT tab2.id, tab2.NAME, tab2.p_id FROM ( SELECT @r AS _id, ( SELECT @r := p_id FROM dc_location WHERE id = _id ) AS pid, @l := @l + 1 AS lvl FROM ( SELECT @r := #{id}, @l := 0 ) vars, dc_location
2021-09-16 10:22:05 511
原创 MySQL查询当前时间到两个小时之前的时间列表(每十分钟)
SELECT tab.dt FROM ( SELECT DATE_FORMAT( date_add( concat( DATE_SUB( NOW(), INTERVAL 2 DAY_HOUR ) ), INTERVAL ( help_topic_id ) MINUTE ), '%Y-%m-%d %H:%i' ) dt FROM mysql.help_topic WHERE help_topic_id <= timestampdiff( MINUTE
2021-09-16 10:12:52 1770
转载 MySQL查询当月第一天到当天的日期列表
SELECT ADDDATE( tab2.firstDay, tab1.firstDay - 1 ) AS date FROM ( SELECT 1 AS firstDay UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL
2021-09-16 09:57:25 672
原创 java实现0001 0002 0003 自增
public static String addNum(String str) { String numStr = str.substring(str.length() - 4); //取出最后四位数字 if (!StringUtils.isEmpty(numStr)) { //如果最后四位不是数字,抛NumberFormatException异常 int n = numStr.length(); //取出字符串的长度 int.
2021-08-10 13:14:30 5244
原创 sql查询取第一条数据
数据全查询SELECT * FROM edu_course ec ORDER BY priceMySQLSELECT * FROM edu_course ec ORDER BY price DESC LIMIT 1sqlserverSELECT TOP 1* FROM edu_course ec ORDER BY price DESCOracleSELECT * FROM(SELECT * FROM EDU_COURSE ORDER BY price DESC) WHERE ROWN
2021-07-14 17:54:32 20080 1
原创 sql截取时分:15小时26分钟
sql截取时分:15小时26分钟sqlserverSELECT SUBSTRING('15小时26分钟', 0, charindex( '小时', '15小时26分钟', 1 ) ) AS '时', SUBSTRING('15小时26分钟', CHARINDEX( '时', '15小时26分钟' ) + 1, CHARINDEX( '分', '15小时26分钟' ) - CHARINDEX( '时', '15小时26分钟' ) - 1 ) AS '分'MySQLSELECT SUBSTRI
2021-07-14 17:18:50 1160
空空如也
根据name去重,如果相同名字下的status存在0和1,取1
2022-01-12
关于feign调用不支持arraylist参数
2021-08-28
TA创建的收藏夹 TA关注的收藏夹
TA关注的人