mysql中insert插入

<!--初始化学生数据插入历史学生信息表中-->
    <insert id="insertStudentHistory" parameterType="com.bjs.glasses.entity.census.CensusStudentInfoExp">
        INSERT INTO census_student_history_info (
            student_id,school_code,company_code,student_name,student_code,student_gender,nation,student_age,
            student_identity,student_birthday,student_mobile,grade_id,class_id,area_code,area_name,school_name,grade_name,class_name,term,remark,
            reg_user_code,upd_user_code
        ) SELECT
              a.student_id,a.school_code,a.company_code,a.student_name,a.student_code,a.student_gender,a.nation,a.student_age,
              a.student_identity,a.student_birthday,a.student_mobile,a.grade_id,a.class_id,c.area_code,c.area_name,b.school_name,d.grade_name,f.class_name,
              #{term,jdbcType=VARCHAR},a.remark,
              #{regUserCode},#{regUserCode}
        FROM census_student_info a left join census_school_info b on a.school_code=b.school_code and b.delete_flag='0' and a.company_code=b.company_code
                                   left join census_area_manage c on c.area_code=b.area_code and c.company_code=b.company_code and c.delete_flag='0'
                                   left join census_grade_info d on a.grade_id=d.id and c.company_code=d.company_code and d.delete_flag='0'
                                   left join census_class_info f on a.class_id=f.id and c.company_code=f.company_code and f.delete_flag='0'

        WHERE a.delete_flag = '0' and a.company_code=#{companyCode}
        <if test="schoolCode != null and schoolCode != ''">
            and a.school_code = #{schoolCode,jdbcType=VARCHAR}
        </if>
    </insert>