qq_17394183的博客

方案1：select (case when A-cast(A as signed)>0.5 then cast(cast(A as signed) as decimal)+0.5else cast(cast(A as signed) as decimal) end ) as col1from t1方案2：DECLARE @T TABLE(Col1 DECIMAL(18,2))IN...

转载至：https://blog.youkuaiyun.com/guoleiding888/article/details/54426052在网上查阅了很多方法，我尝试了用后台java，但实现起来比较麻烦，最后自己探索用纯sql来实现，记录起来分享下。mysql 按月分组累计统计数据，想得到如下的结果，如下图：【year_and_month】- 显示按月分组查询的字段【count_per_month...

断层描述：断层的SQL为：WITH temp AS (SELECT SUBSTR(T.entry_time FROM 1 FOR 7) AS cal_month, COUNT(1) AS per_monthFROM ziguang-personnal.employee TWHERE T.status = 1AND YEAR(NOW())>= SUBSTR(T.entry_time...

卸载方法：1.快速删除yum remove mysql mysql-server mysql-libs mysql-server2.查找残留文件rpm -qa | grep -i mysql将查询出来的文件逐个删除，如：yum remove mysql-community-common-5.7.20-1.el6.x86_644.查找残留目录whereis mysql逐条删除目录...

安装：转自https://segmentfault.com/a/1190000003049498检测系统是否存在mysqlyum list installed | grep mysql删除mysql依赖项yum -y remove mysql-libs.x86_643.给CentOS添加rpm源，并且选择较新的源wget dev.mysql.com/get/mysql-communi...