翻译过来就是  “id” 这一列含糊不清 大多出现在连表查询并且都有相同的字段（id）

<select id="getInsuranceInfoById" parameterType="java.lang.Integer" resultMap="item">
	select
		<include refid="base_column_list" />, 
                s.name as storeName, u2.name as updateNameQuery
	from insurance_info i left join store s on
		i.storeId = s.id
		left join user_info u2 on u2.id = i.updateId
	where id = #{id} 
		order by i.updateTime desc
</select>

在mysql最后的 where条件中的 id 没有添加别名 i 导致报错

 

应该是：

<select id="getInsuranceInfoById" parameterType="java.lang.Integer" resultMap="item">
		select
		<include refid="base_column_list" />, s.name as storeName, u2.name as updateNameQuery
		from insurance_info i left join store s on
		i.storeId = s.id
		left join user_info u2 on u2.id = i.updateId
		where i.id = #{id} 
		order by i.updateTime desc
	</select>