mybatis中sql语句支持mysql中的变量吗

比如

set @num := 0, @type :='';
insert语句

可以执行存储过程

insert into [City]
(

    [ProvinceId],

    [Number],

    [SerialNumber],

    [Name],

    [EnglishName],

    [Code],

    [Status],

    [Sort],

    [ZipCodeStart],

    [ZipCodeEnd],

    [AirportCode],

    [CreateTime]


  )
  values
  (



    #ProvinceId#,

    #Number#,

    #SerialNumber#,

    #Name#,

    #EnglishName#,

    #Code#,

    #Status#,

    #Sort#,

    #ZipCodeStart#,

    #ZipCodeEnd#,

    #AirportCode#,

    #CreateTime#


  )

insert into [City]
(

    [ProvinceId],

    [Number],

    [SerialNumber],

    [Name],

    [EnglishName],

    [Code],

    [Status],

    [Sort],

    [ZipCodeStart],

    [ZipCodeEnd],

    [AirportCode],

    [CreateTime]


  )
  values
  (



    #ProvinceId#,

    #Number#,

    #SerialNumber#,

    #Name#,

    #EnglishName#,

    #Code#,

    #Status#,

    #Sort#,

    #ZipCodeStart#,

    #ZipCodeEnd#,

    #AirportCode#,

    #CreateTime#


  )

  <selectKey type="post" resultClass="System.Int32" property="Id">
      select @@identity as value
  </selectKey>

</insert>

insert into [City]
(

    [ProvinceId],

    [Number],

    [SerialNumber],

    [Name],

    [EnglishName],

    [Code],

    [Status],

    [Sort],

    [ZipCodeStart],

    [ZipCodeEnd],

    [AirportCode],

    [CreateTime]


  )
  values
  (



    #ProvinceId#,

    #Number#,

    #SerialNumber#,

    #Name#,

    #EnglishName#,

    #Code#,

    #Status#,

    #Sort#,

    #ZipCodeStart#,

    #ZipCodeEnd#,

    #AirportCode#,

    #CreateTime#


  )

  <selectKey type="post" resultClass="System.Int32" property="Id">
      select @@identity as value
  </selectKey>

</insert>

《insert id="insert" parameterClass="City"》

发不上来，用《 代替

mysql连接url + allowMultiQueries=true

jdbc:mysql://localhost:3306/DBS?allowMultiQueries=true

MyBatis java and MySql local variables - Stack Overflow