![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
qq_40852612
这个作者很懒,什么都没留下…
展开
-
使用STRAIGHT_JOIN替换INNER JOIN,解决子查询排序失效问题
MySQL子查询排序失效原创 2023-02-15 17:17:55 · 232 阅读 · 0 评论 -
MySQL插入数据时查询已有数据并设置为字段值
MySQL插入数据时查询已有数据并设置为字段值原创 2022-11-08 14:34:09 · 982 阅读 · 0 评论 -
mysql无效的语句不一定会导致报错
SELECT *FROM t_testWHERE create_user = '1399627302760910850'AND '健康的说法45345'原创 2021-06-02 17:28:32 · 87 阅读 · 0 评论 -
mybatis遍历Map
<insert id="insert" parameterType="com.modular.table.param.CustomDataParam"> insert into ${param.tableName} <foreach collection="param.params.keys" item="key" open="(" close=")" separator=","> ${key.原创 2021-05-11 16:04:37 · 5253 阅读 · 1 评论 -
MySQL数据库关键字集合
public static List<String> keyList() { String[] keys = {"ADD", "ALL", "ALTER", "ANALYZE", "AND", "AS", "ASC", "ASENSITIVE", "BEFORE", "BETWEEN", "BIGINT", "BINARY", "BLOB", "BOTH", "BY", "CALL", "CASCADE", "CASE", "CHANGE", ".原创 2021-04-02 13:50:20 · 516 阅读 · 0 评论 -
spring boot中,使用LocalDateTime.now()相差八小时
解决方法:在启动类中加入代码:@SpringBootApplicationpublic class SwappingApplication { public static void main(String[] args) { SpringApplication.run(SwappingApplication.class, args); } @PostConstruct void started() { // Tim原创 2021-03-10 10:15:38 · 4277 阅读 · 0 评论 -
mybatis中一对一,一对多
<resultMap type="SysUser" id="SysUserResult"> <id property="userId" column="user_id" /> <result property="deptId" column="dept_id" /> <result property="userName" column="user_name" /> &l...原创 2021-02-20 18:16:31 · 186 阅读 · 0 评论 -
hibernate的order by 失效
在hql语句中,多写了一个 ")" ,导致 order by 字段 desc 不生效(但是在火狐浏览器中可以生效),去掉括号后排序字段生效了!大坑啊,还好我火眼金睛,找到了那个多余的 ")" ,哈哈哈哈!...原创 2019-10-12 16:11:51 · 554 阅读 · 0 评论 -
mysql(find_in_set)判断某个字符在另一个以逗号分割的字符中(2)
原创 2019-09-09 16:43:32 · 276 阅读 · 0 评论