qq_39234840的博客

mysql 5.7版本数据库json字段筛选

select firm_name,sum(case month(time) when '1' then 1 else 0 end) as 一月份,sum(case month(time) when '2' then 1 else 0 end) as 二月份,sum(case month(time) when '3' then 1 else 0 end) as 三月份,sum(case ...

报错：#4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ws.t_sys_cat.ARG1' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_m...

windows2008 r2版本：卸载服务在命令行输入net stop mysqld:\mysql\bin\mysqld -remove安装服务在命令行输入d:\mysql\bin\mysqld -installnet start mysql开始——》管理工具——》服务...

登录数据库：# mysql -u root -p输入密码首先mysql的用户账号以及权限信息都保存在mysql.user表中查询mysql.user的所有用户信息SELECT host,user,authentication_string password FROM mysql.user;以下新建用户和修改权限语法与数据库版本有关1、新建数据库账...

使用group_concat（）配合GROUP BYSELECT group_concat(share_ord_date.star_time),share_ord.* FROM `share_ord`left JOIN share_ord_date on share_ord_date.share_ord_id=share_ord.idGROUP BY share_ord.id; ...

今天在项目中碰到这样的报错，原因是特殊字符无法插入数据库，只需要将数据库字段做以下修改：项目为微信公众号，其中微信用户的昵称，当你读取保存的时候用户的微信昵称可能包含特殊字符所以在数据库所有有关保存用户微信昵称的字段都必须修改成utf8mb4的字符集...

 1：如果数据库表字段的字符编码是latin1_swedish_ciselect * from tablename order by birary(name) asc ; 2：如果数据库表字段的字符编码是utf8_general_ci（常用）select * from tablename WHERE 1=1 order by CONVERT( name USING gbk ...

select a.* FROM(SELECT *,DATE_ADD(create_date, INTERVAL 10 MINUTE)<SYSDATE() isDelayFROM `car_teams_ord`) a where IF(iss_price=1||iss_price=0,1=1,a.isDelay=1)思路：1、DATE_ADD(create_date, IN...

SELECT *FROM T_ORDWHEREIF ( xd__T_ORD.LOG_STAT_CD >= 3050.160,-- 条件 LOG_STAT_CD >= 3050.160 -- true AND LOG_STAT_CD <= 3050.220, AND LOG_STAT_CD ...

场景：如上筛选出订单创建超出15分钟的订单并做删除操作  select * FROM `t_ord` WHERE date_sub(NOW(), interval '0 0:15:0' day_second)&gt;CRT_TM如上使用： date_sub(NOW(), interval '0 0:15:0' day_second)可以把当前时间减去15分钟再与订单创建时间进行对比...