Girlish Code

[code="sql"]insert into users (last_name,pwd,purview,email) values('txl','12345','view','yztxl@eyou.com'); select @@identity[/code]

[code="java"]package com.ada.dao.impl;import org.hibernate.Criteria;import org.hibernate.criterion.Projections;import com.ada.bean.Page;public class MyDAOSupport { /** 分页查询方法 ...

原来的写法：[code="sql"]select a.flow_id,a.flow_name from t_flow_type a where a.flow_id not in ( select flow_id from t_delay_count_flow);[/code]不使用not in的写法：[code="sql"]select a.flow_id,a.flow_n...

1.自增主键[code="sql"]load datainfile 'sgsnlist'truncate into table SGSNLISTfields terminated by ","trailing nullcols(SGSNINDEX sequence(max,1),SGSNADDRESS,GGSNHOST)[/code]2.日期...