转诊系统导入脚本

分类

现在位置: 首页＞ MySQL ＞正文

转诊系统导入脚本

2015-05-25 14:35 MySQL 暂无评论阅读(1,808)

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.doctorid > 2983
AND doctor.DoctorHospitalCode IS NULL
AND hospital.parentcode = '00010019'
SET doctor.DoctorHospitalCode=hospital.hospitalcode
UPDATE doctor SET doctorpwd = '670B14728AD9902AECBA32E22FA4F6BD'
WHERE doctorpwd=''
#添加权限
INSERT INTO nch_dts.`doctor_role` (doctorguid,doctorname,doctoridnumber,rolecode,rolename)
SELECT NULL,doctorname,doctoridnumber,2,'医生'
FROM doctor
WHERE doctorid>2983