转诊系统导入脚本

SELECT * FROM doctor WHERE doctorid>2983     INSERT INTO doctor   (createtime,doctorname,doctoridnumber,doctorbirthday,doctorsex,doctornation,doctorhospitalname,  doctorpwd,doctortel,createusername)   SELECT NOW(),`姓名`,`身份证号`,`出生年月日`,`性别`,'汉',`所属单位`,'',`电话`,'admin' FROM `sheet1`  WHERE `身份证号` NOT IN (SELECT doctoridnumber FROM doctor)        UPDATE doctor INNER JOIN hospital    ON doctor.doctorhospitalname=hospital.hospitalname   AND doctor.doct...