mysql自增主键和mybatis自增主键不一致问题(已解决):
在插入数据前,先进行查询主键
<insert id="insertSelective">
<selectKey keyProperty="zxywzj" resultType="Integer">
select LAST_INSERT_ID()
</selectKey>
insert into tb_name
(<include refid="if_insert_column"/>)
values
(<include refid="if_insert_value"/>)
</insert>
//关键性代码 keyProperty="id" 为你的表主键
<selectKey keyProperty="id" resultType="Integer">
select LAST_INSERT_ID()
</selectKey>