Mysql实现日期排序null记录放前后 null在前面#field1与field2同一个字段ORDER BY NOT ISNULL(field1), field2 ASC|DESCnull在后面#field1与field2同一个字段ORDER BY ISNULL(field1), field2 ASC|DESC
SpringMVC调接口报错:No converter found for return value of type org.springframework.http.converter.HttpMessageNotWritableException: No converter found for return value of type: class org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessag
企业微信(创建群聊会话)60011错误 微信企业调创建群聊会话接口遇到的错误:{ “errcode”: 60011, “errmsg”: “no privilege to access/modify contact/party/agent , hint: [1592208279_79_2afcb2fb3a784dbe93c228fc748f2746], from ip: 100.66.97.245, more info at https://open.work.weixin.qq.com/devtool/query?e=60011” }说明:
关于Mysql的EXISTS/NOT EXISTS字段使用注意 说明:EXISTS 用于判断查询子句是否有记录,如果有一条或多条记录存在返回 True,否则返回 False。注意事项:当查询有多个条件时,EXISTS条件要放在最后
idea同时打开多个同一个文件 前提:一个文件内容太多,想同时查看页首与页尾不同方法的代码。打开idea设置,快捷键设置,输入:Open In New Editor window然后选中文件,按快捷键即可。
mysql多表联合修改表记录时,需要指定别名 com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column ‘cust_id’ in field list is ambiguous; Column ‘cust_id’ in field list is ambiguous; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationExce
java.lang.IllegalArgumentException: invalid comparison: java.util.ArrayList and java.lang.String的问题 :nested exception is org.apache.ibatis.exceptions.PersistenceException:Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.ArrayList and java.lang.StringCause: java.lang.IllegalArgumentException: invalid com
springboot2.1.6 quartz定时任务启动报错 org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘quartzScheduler’ defined in class path resource [org/springframework/boot/autoconfigure/quartz/QuartzAutoConfiguration.class]: Invocation of init method failed; nested