mysql使用积累

同步两张表数据，并做部分改造

insert into t_student(source, source_type, period,
                      source_code,graduation_date,student_number)
select 'xxx大学',
       '学生数据',
       ifnull(date_format(graduation_date,'%Y%m'),0),
       'STUDENT_NUM',
       graduation_date,
       student_number
from t_student_temp t
where not exists(select 1
                 from t_student tt
                 where tt.student_number= t.student_number);