- 博客(5)
- 资源 (4)
- 收藏
- 关注
RSS订阅原创 log4j2配置详解
//status用来指定log4j本身的打印日志的级别.<Configuration status="info"> //配置输出文件 <properties> <property name="LOG_HOME">logs/</property> <property name="FILE_NAME"&am
2018-10-18 15:55:53
738
原创 string的substring方法源码解析
/** * Returns a string that is a substring of this string. The * substring begins with the character at the specified index and * extends to the end of this string. <p> * ...
2018-10-18 10:08:24
1140
原创 sql 去重 查找并删除重复记录并且只留一条记录
1.支持单条件或者多条件，查找重复记录，语句：select * from stock a where (a.state,a.org_id,a.material_id) in (select state,org_id,material_id from stock where state = 1 group by state,org_id ,material_id having co...
2018-10-12 14:30:10
2458
原创 You can’t specify target table for update in FROM clause（sql语句错误解决方法）
1.首先“You can’t specify target table for update in FROM clause”，这句话的意思是：不能先select出同一表中的某些值，再update这个表(在同一语句中)2.eg：一个错误例子select * from vitae a where (a.peopleId,a.seq) in (select peopleId,seq fr...
2018-10-12 14:11:03
6858
3
原创 Every derived table must have its own alias（sql语句错误解决方法）
1. 在做多表查询，或者查询的时候产生新的表的时候会出现这个错误：Every derived table must have its own alias（每一个派生出来的表都必须有一个自己的别名）。eg：delete from stock where (org_id,material_id,state) in (SELECT * from (select org_id,ma...
2018-10-12 11:38:18
476642
17
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人