weixin_39300480的博客

原创 SELECT list is not in GROUP BY clause and contains nonaggregated column

》》》》》原文链接《《《《《

原创 mybatis返回实体参数嵌套方法，通过resultMap

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.jf.exmpe.mappe...

原创 mybatis mysql in查询优化

当数据库查询，传入list参数作为查询条件，数据量较大时，进行优化，将in转为inner join，mapper.xml中：<select id="listExistOrgCode" resultType="java.lang.String"> select a.org_code from jf_vis_db.vms_video_orgrange a ...

原创 MySQL数据库FIND_IN_SET函数的使用

》》》》》原文链接《《《《《

原创 Mybatis mapper.xml foreach标签 UNION ALL