mysql插入语句将一张表插入另外一张表并且不重复插入

INSERT INTO rt_admission (middle_school_id,student_id,name,student_code,sample_id,school_id,class_id,district_id,identify,admission_type,
student_type,status,report_status,report_time,ack_status,ack_time,ksy_status,add_district_id,minadmission_type,is_interview,
is_acceptinterview,pwmark) SELECT * from (SELECT 101314 as middle_school_id,id as 'student_id',name,student_code,sample_id,school_id,class_id,district_id,identify,
'volunteer' as admission_type,student_type,7 as status,
1 as report_status,NOW() as report_time,1 as ack_status,NOW() as ack_time,0 as ksy_status,0 as add_district_id,'派位录取' as 'minadmission_type',0 as is_interview,
'' as is_acceptinterview,'派位中签' as pwmark  
from rt_student where id in(1901010022202,1999999990051,1999999990052,1999999990054)) tt WHERE not EXISTS (select * from rt_admission ta where ta.student_id=tt.student_id);