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);
博客
前端高频面试(1)
06-21
152
04-10
450
04-08
270
02-02
981
02-01
178
博客
Uniapp上传图片
01-09
395
12-11
437
12-11
436
11-27
494
10-19
207