id, province_id, province select from sys_provinces select from sys_provinces where id = #{id,jdbcType=INTEGER} delete from sys_provinces where id = #{id,jdbcType=INTEGER} insert into sys_provinces (id, province_id, province ) values (#{id,jdbcType=INTEGER}, #{provinceId,jdbcType=VARCHAR}, #{province,jdbcType=VARCHAR} ) insert into sys_provinces id, province_id, province, #{id,jdbcType=INTEGER}, #{provinceId,jdbcType=VARCHAR}, #{province,jdbcType=VARCHAR}, update sys_provinces province_id = #{provinceId,jdbcType=VARCHAR}, province = #{province,jdbcType=VARCHAR}, where id = #{id,jdbcType=INTEGER} update sys_provinces set province_id = #{provinceId,jdbcType=VARCHAR}, province = #{province,jdbcType=VARCHAR} where id = #{id,jdbcType=INTEGER} SELECT province FROM sys_provinces WHERE province_id=#{provinceId}