MySQL

insert into kpidata (create_time, modify_time, applyDate, description, endTime, startTime, value, kpi_id)values (now(), now(), '2017-04-01 00:00:00', '当月报警数环比增长率', now(), now(), -0.10943667025475422, 3001),(now(), now(), '2017-04-01 00:00:00', '当月治安案件数环比增长率', now(), now(), -0.010638297872340425, 3002),(now(), now(), '2017-04-01 00:00:00', '当月刑事案件数环比增长率', now(), now(), -0.02619047619047619, 3003),(now(), now(), '2017-04-01 00:00:00', '当月交通事故数环比增长率', now(), now(), -0.03360392675099113, 3004);

-- 修改日期中的某一部分，比如年份 update criminal_data set applyTime = str_to_date(concat(year(applyTime),'-',month(applyTime),'-01'),'%Y-%m-%d');
-- 复制上一年的某月份数据 表【police_call_data】
Insert Into police_call_data(CRIMINAL, ELSECASE, FIRE, MONTH, POLICE, trafficAccident, YEAR, policeStation, applyTime, policeStation_id) select CRIMINAL, ELSECASE, FIRE, 9, POLICE, trafficAccident, 2016, policeStation, '2016-09-01', policeStation_id from police_call_datawhere applyTime = '2015-09-01 xx:xx:xx';
select * FROM kpidata where (kpi_id=3010 or kpi_id= 3001 or kpi_id=3014 or kpi_id=3002 or kpi_id=3011 or kpi_id=3003 or kpi_id=3004 or kpi_id=3017 or kpi_id=3020 or kpi_id=3021 or kpi_id=3022 or kpi_id=3013 or kpi_id=3005 or kpi_id=3006 or kpi_id=3007 or kpi_id=3008  or kpi_id=3023 or kpi_id=3024 or kpi_id=3019 or kpi_id=3009 or kpi_id=3015 or kpi_id=3016) and `applyDate` > '2016-12-31 21:30:32';

UPDATE `iockpinew`.`police_call_data` SET `FIRE`=NULL WHERE  applyTime > '2016-07-30';


select count(p.policeStation_id), p.policeStation_id, d.name from police_call_data p, dict_data d where p.policeStation_id = d.id group by policeStation_id 
 
 update criminal_data set applyTime =  str_to_date(concat(year(applyTime),'-',month(applyTime),'-01'),'%Y-%m-%d'); 
                                             
        1        0           
	
				
	
					   
Mysql
	  	   
MySql
	  	   
MYSQL
	  	   
MySQL
	  	   
mysql
	  	   
mysql
	  	   
mysql
	  	   
mysql
	  	   
Mysql
	  	   
Mysql
	  	   
mysql
	  	   
MySQL
	  	   
mysql
	  	   
Mysql
	  	   
mysql
	  	   
mysql
	  	   
mysql
	  	   
mySQL
	     		  
	  	   
sem_init,sem_post,sem_wait 信号量的用法解释
	  	   
第五章 传输层
	  	   
Servlet的多线程并发问题
	  	   
js利用window对象缓存变量
	  	   
Weblogic JNDI数据源配置及查看
	  	   
MySQL
	  	   
JavaScript操作css样式
	  	   
关于HTML5你必须知道的28个新特性,新技巧以及新技术
	  	   
快速提高编辑效率支持一键导入word文档-逐浪CMS
	  	   
[BZOJ2337][HNOI2011]XOR和路径（概率期望dp+高斯消元）
	  	   
ServletConfig对象
	  	   
二叉树-你必须要懂！（二叉树相关算法实现-iOS）
	  	   
boost高并发网络框架+线程池
	  	   
ASP.NET MVC设计目的