id, city_id, city, province_id select from sys_cities where province_id = #{provinceId,jdbcType=VARCHAR} select from sys_cities where id = #{id,jdbcType=INTEGER} select from sys_cities delete from sys_cities where id = #{id,jdbcType=INTEGER} insert into sys_cities (id, city_id, city, province_id) values (#{id,jdbcType=INTEGER}, #{cityId,jdbcType=VARCHAR}, #{city,jdbcType=VARCHAR}, #{provinceId,jdbcType=VARCHAR}) insert into sys_cities id, city_id, city, province_id, #{id,jdbcType=INTEGER}, #{cityId,jdbcType=VARCHAR}, #{city,jdbcType=VARCHAR}, #{provinceId,jdbcType=VARCHAR}, update sys_cities city_id = #{cityId,jdbcType=VARCHAR}, city = #{city,jdbcType=VARCHAR}, province_id = #{provinceId,jdbcType=VARCHAR}, where id = #{id,jdbcType=INTEGER} update sys_cities set city_id = #{cityId,jdbcType=VARCHAR}, city = #{city,jdbcType=VARCHAR}, province_id = #{provinceId,jdbcType=VARCHAR} where id = #{id,jdbcType=INTEGER} select city from sys_cities where city_id=${cityId}