摘要:
SELECT a.*, c.`name` reservoirName FROM 数据表 a INNER JOIN ( SELECT SUBSTRING_INDEX(GROUP_CONCAT(id ORDER BY op_time DESC, id DESC),',',1) id FROM 数据表 G 阅读全文
摘要:
Long len = redisTemplate.opsForList().size(CacheConstants.CACHE_LOG_LIST); if (len != null && len > 0) { long i = len / 1000 + 1; while (i > 0) { List 阅读全文
摘要:
public static void main(String[] args) { JSONArray jsonArray = new JSONArray(); for (int i = 1; i < 11; i++) { JSONObject jsonObject = new JSONObject( 阅读全文
摘要:
1. GROUP_CONCAT, CONCAT_WS,, ORDER BY 组合使用 SELECT tmi.id, tmi.task_name AS taskName, JSON_UNQUOTE( JSON_EXTRACT( tmi.cooperate_dept, '$[*].name' ) ) A 阅读全文