- 博客(4)
- 资源 (5)
- 收藏
- 关注
原创 mysql性能优化
【性能提升神器】STRAIGHT_JOIN今天给大家下另一个性能提升神器-STRAIGHT_JOIN,在数据量大的联表查询中灵活运用的话,能大大缩短查询时间。首先来解释下STRAIGHT_JOIN到底是用做什么的:STRAIGHT_JOIN is similar to JOIN, except that the left table is always read before the right table.This can be used for those (few) cases for whi
2021-12-15 21:46:17
50
原创 mysql查询所有父节点和子节点
SELECT*FROMqx_areaWHERE(FIND_IN_SET(id,‘130100,140000’)OR FIND_IN_SET( 130100, parent_ids )OR FIND_IN_SET( 140000, parent_ids )OR FIND_IN_SET(id,(SELECTGROUP_CONCAT(parent_ids)FROMqx_areaWHEREFIND_IN_SET(id,‘130100,140000’))))
2021-11-30 15:50:13
378
原创 Java发送文件
public static void main(String[] args) { DataOutputStream out = null; final String newLine = "\r\n"; final String prefix = "--"; try { String url1=// “”;URL url = new URL(url1);HttpURLConnection conn = (HttpURLConnection)url.openConnecti
2021-11-25 11:01:49
258
原创 mysql删除重复数据
DELETEFROMqx_site_weather_hourWHEREid IN (SELECTm.idFROM(SELECTidFROMqx_site_weather_hour A,( SELECT site_id, date_time FROM qx_site_weather_hour GROUP BY site_id, date_time HAVING COUNT() > 1 ) BWHEREA.site_id = B.site_idAND A.date_time
2021-11-23 11:00:03
1623
feign-slf4j-9.5.0.jar
2019-06-20
feign-core-9.5.0.jar
2019-06-20
jQuery EasyUI 1.4.1 版 API 中文
2016-08-13
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人