mybatis进行批处理更新失败，控制台报sql语法错误You have an error in your SQL syntax； check the man....

mybatis的批量更新简单语句

<update id="updateUserGetEvaluateScore" parameterType="list">
   <foreach collection="list" item="userTotalScore" index="index" separator=";">
      update user_score
      <set>
          user_score = #{userTotalScore.userScore},
          end_time = now()
      </set>
      where user_name = #{userTotalScore.userName}
   </foreach>
</update>

上面的语法是没有问题的，但是一执行会报错

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update user_score
             SET user_score = 25,
                end_time = n' at line 6...

经过广大网友的分析，原来mysql是不允许在sql语句后携带分号&