四块五

摘要： org = org.stream().sorted(Comparator.comparing(SynchronousDataService::sort2)).collect(Collectors.toList());// 排序 private static String sort2(Map<Stri 阅读全文

摘要： SELECT '字段1', '字段2', '字段3', @rownum :=@rownum + 1 AS itemFROM 表名, (SELECT @rownum := 0) temp 阅读全文

摘要： load data local infile #{url} replace into table SAM_ORDERSIGN_EXCEL_TEMP fields terminated by ',' enclosed by '"' LINES TERMINATED BY #{linefeed} ign 阅读全文

摘要： DROP TEMPORARY TABLE IF EXISTS `SAM_ORDERSIGN_EXCEL_TEMP`; CREATE TEMPORARY TABLE `SAM_ORDERSIGN_EXCEL_TEMP` ( `CHANNEL` varchar(80) COLLATE utf8_bin 阅读全文

摘要： 抓当前组织及下级组织：WITH RECURSIVE AA AS ( SELECT HIGHER_ORGANIZATION AS ORGANIZATION FROM BAS_ORGANIZATION_HIERARCHY WHERE HIGHER_ORGANIZATION = '330101' AND 阅读全文

摘要： 查看索引：SHOW INDEX FROM 表名删除索引：ALTER TABLE `表名` drop index `idx_phone_no` 添加索引：ALTER TABLE `表名` ADD INDEX `idx_phone_no` (`PHONE_NO` ASC) COMMENT ''; （PH 阅读全文

摘要： 代码：List<Map<String,Object>> list = null; //list中放入数据集后根据每一笔map中的order_no字段进行冒泡排序 list.sort((Map<String,Object> h1,Map<String,Object> h2) -> ((String) 阅读全文