Mysql如何获取自增主键ID？

另一篇博客：Oracle如何获取自增主键ID？
Mybatis.xml

<insert id="insertStudentInfo" parameterType="StudentInfo">
    <selectKey keyProperty="id" order="AFTER" resultType="java.lang.Long">
        SELECT LAST_INSERT_ID()
    </selectKey>
    insert into student_info
    <trim prefix="(" suffix=")" suffixOverrides=",">
        <if test="studentId != null "> student_id,</if>
        <if test="studentNo != null and studentNo != '' "> student_no,</if>
        <if test="studentName != null and studentName != '' "> student_name,</if>
      </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
        <if test="studentId != null ">#{studentId},</if>
        <if test="studentNo != null and studentNo != '' ">#{studentNo},</if>
        <if test="studentName != null and studentName != '' ">#{studentName},</if>
      </trim>
</insert>