mybatis+mysql返回插入的主键，参数只是提供部分参数

  <insert id="insertByChannelIdOpenid"  useGeneratedKeys="true" keyProperty="id"  parameterType="com.model.StatisticSaler" >
      insert into statistic_saler(city_id,shop_id,saler_id,type,openid,time)
      select city_id,shop_id,saler_id,#{type,jdbcType=VARCHAR},#{openid,jdbcType=VARCHAR},now() 
      from channel s where s.id = #{id,jdbcType=INTEGER}
  </insert>