📄 hosdoctor.sql
字号:
CREATE TABLE hosdoctor (
hoscode char(4),
code char(4),
name char(10),
sex float,
belong char(20),
pycode char(5),
wbcode char(5),
effectflag float,
updateflag float);
INSERT INTO hosdoctor VALUES (
'0001',
'01',
'林忠桂',
1,
'门诊部',
'LZG',
'SKS',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'02',
'肖国新',
1,
'门诊部',
'XGX',
'ILE',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'03',
'林耀玲',
0,
'门诊部',
'LZL',
'SIG',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'04',
'林全忠',
1,
'门诊部',
'LCZ',
'SWK',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'05',
'吕彩明',
1,
'门诊部',
'LCM',
'KEJ',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'06',
'陈远才',
1,
'门诊部',
'CYC',
'BFF',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'07',
'陈旭',
1,
'门诊部',
'CS',
'BV',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'08',
'陈 艳',
0,
'门诊部',
'CY',
'BD',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'09',
'陈彩英',
0,
'门诊部',
'CCY',
'BEA',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'10',
'阮明军',
1,
'门诊部',
'YMG',
'BJT',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'11',
'吕彩明',
1,
'门诊部',
'LCM',
'KTJ',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'12',
'江泽湘',
1,
'门诊部',
'JZX',
'III',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'13',
'陈翠忠',
1,
'门诊部',
'CCZ',
'BNK',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'14',
'吕德文',
1,
'急诊科',
'LDW',
'KTY',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'15',
'苏洛辛',
1,
'急诊科',
'SLX',
'AIY',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'16',
'黎文武',
1,
'急诊科',
'LWW',
'TYF',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'17',
'梁令武',
1,
'急诊科',
'LLW',
'IWF',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'18',
'李杰邦',
1,
'急诊科',
'LJB',
'SSD',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'19',
'何世聪',
1,
'急诊科',
'HSC',
'TAB',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'20',
'梁升庆',
1,
'急诊科',
'LSQ',
'ITY',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'21',
'曾家华',
1,
'急诊科',
'ZJH',
'UPW',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'22',
'陈 波',
0,
'功能科',
'CB',
'BI',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'23',
'陈宇迪',
0,
'功能科',
'CYJ',
'BPP',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'24',
'陈 希',
0,
'功能科',
'CX',
'BI',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'25',
'林忠超',
1,
'功能科',
'LCZ',
'SKF',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'26',
'韦春斌',
1,
'门诊部',
'WCB',
'FDU',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'27',
'谢权',
1,
'门诊部',
'SP',
'YS',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'28',
'李诗荣',
1,
'门诊部',
NULL,
'SYA',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'29',
'谢家奇',
1,
'门诊部',
NULL,
'YPD',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'30',
'李志光',
1,
'门诊部',
NULL,
'SFI',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'31',
'姚盛均',
1,
'门诊部',
NULL,
'VDF',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'32',
'陈旭',
1,
'门诊部',
NULL,
'BV',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'33',
'杨福亮',
1,
'门诊部',
NULL,
'SPY',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'34',
'陈凤芬',
0,
'门诊部五官',
NULL,
'BMA',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'35',
'吕春能',
1,
'门诊部五官',
NULL,
'KDC',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'36',
'陈玲',
0,
'门诊部五官',
NULL,
'BG',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'37',
'宁强',
1,
'门诊部五官',
NULL,
'PX',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'38',
'陈业坚',
1,
'门诊部五官',
NULL,
'BOJ',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'39',
'邱景业',
1,
'门诊部五官',
NULL,
'RJO',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'40',
'邱健明',
1,
'门诊部',
NULL,
'RWJ',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'41',
'周福',
1,
'康复科',
NULL,
'MP',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'42',
'宁强',
1,
'内科一区',
NULL,
NULL,
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'43',
'金光',
1,
'门诊部五官',
NULL,
'QI',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'44',
'林泽萍',
0,
'门诊部五官',
NULL,
'SIA',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'45',
'吴瑞珍',
0,
'妇产科门诊',
NULL,
'KGG',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'46',
'吕健燕',
0,
'妇产科门诊',
NULL,
'KWA',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'47',
'邱永',
1,
'门诊部',
NULL,
'RY',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'48',
'吕斌',
1,
'急诊部',
NULL,
'KY',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'49',
'陈业泉',
1,
'门诊部',
NULL,
'BOR',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'50',
'何文威',
1,
'门诊部',
NULL,
'WYD',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'51',
'吕权',
1,
'外二科',
NULL,
'KS',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'52',
'姚兆海',
1,
'外二科',
NULL,
'VII',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'53',
'高志明',
1,
'外二科',
NULL,
'YFJ',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'54',
'林翰',
1,
'外二科',
NULL,
'SF',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'55',
'李华胜',
1,
'外二科',
NULL,
'SWE',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'56',
'陈子才',
1,
'脑系科',
NULL,
'BBF',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'57',
'陈业华',
1,
'脑系科',
NULL,
'BOW',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'58',
'黄镇',
1,
'脑系科',
NULL,
'AQ',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'59',
'梁勇基',
1,
'脑系科',
NULL,
'ICA',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'60',
'莫广平',
1,
'脑系科',
NULL,
'AYG',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'61',
'姚兆海',
1,
'脑系科',
NULL,
'VII',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'62',
'冯敏',
1,
'内三科',
NULL,
'UT',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'63',
'吕海明',
1,
'内三科',
NULL,
'KIJ',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'64',
'陈春丽',
1,
'内三科',
NULL,
'BDG',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'65',
'梁升庆',
1,
'内三科',
NULL,
'ITY',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'66',
'吕建军',
1,
'内三科',
NULL,
'KVP',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'67',
'梁令武',
1,
'内三科',
NULL,
'IWG',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'68',
'周瑞有',
1,
'外一科',
NULL,
'MGE',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'69',
'罗瑞忠',
1,
'外一科',
NULL,
'LGK',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'70',
'刘昌强',
1,
'外一科',
NULL,
'YJX',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'71',
'李胜',
1,
'外一科',
NULL,
'SE',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'72',
'李伟邦',
1,
'外一科',
NULL,
'SWD',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'73',
'李泽荣',
1,
'内一科',
NULL,
'SIA',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'74',
'黄建新',
1,
'内一科',
NULL,
'AVU',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'75',
'王扬光',
1,
'急诊部',
NULL,
'GRI',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'76',
'陈兰芳',
0,
'门诊妇科',
NULL,
'BUA',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'77',
'谭金辉',
1,
'门诊部',
NULL,
'YQI',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'78',
'徐卫东',
0,
'门诊妇科',
NULL,
'TBA',
1,
1);
INSERT INTO hosdoctor VALUES (
'0001',
'79',
'罗庚秋',
0,
'门诊妇科',
NULL,
'LYT',
1,
1);
INSERT INTO hosdoctor VALUES (
'0006',
'01',
'吕昆才',
1,
'门诊',
NULL,
'KJF',
1,
1);
INSERT INTO hosdoctor VALUES (
'0006',
'02',
'陈瑞明',
1,
'门诊',
NULL,
'BGJ',
1,
1);
INSERT INTO hosdoctor VALUES (
'0006',
'03',
'邱凤英',
0,
'门诊',
NULL,
'RMA',
1,
1);
INSERT INTO hosdoctor VALUES (
'0006',
'04',
'陈俭丽',
0,
'妇产科',
NULL,
'BWG',
1,
1);
INSERT INTO hosdoctor VALUES (
'0006',
'05',
'吴国珍',
0,
'妇产科',
NULL,
'KLG',
1,
1);
INSERT INTO hosdoctor VALUES (
'0006',
'06',
'罗海欧',
0,
'妇产科',
NULL,
'LIA',
1,
1);
INSERT INTO hosdoctor VALUES (
'0006',
'07',
'黎彩虹',
0,
'妇产科',
NULL,
'TEJ',
1,
1);
INSERT INTO hosdoctor VALUES (
'0006',
'08',
'刘志清',
1,
'外科',
NULL,
'YFI',
1,
1);
INSERT INTO hosdoctor VALUES (
'0006',
'09',
'吕德强',
1,
'外科',
NULL,
'KTX',
1,
1);
INSERT INTO hosdoctor VALUES (
'0006',
'10',
'林伟明',
1,
'外科',
NULL,
'SWJ',
1,
1);
INSERT INTO hosdoctor VALUES (
'0006',
'11',
'梁剑锋',
1,
'外科',
NULL,
'IWQ',
1,
1);
INSERT INTO hosdoctor VALUES (
'0006',
'12',
'姚希辉',
1,
'内科',
NULL,
'VQI',
1,
1);
INSERT INTO hosdoctor VALUES (
'0006',
'13',
'陈业林',
1,
'内科',
NULL,
'BOS',
1,
1);
INSERT INTO hosdoctor VALUES (
'0006',
'14',
'蓝珂',
0,
'内科',
NULL,
'AG',
1,
1);
INSERT INTO hosdoctor VALUES (
'0006',
'15',
'刘建祥',
1,
'内科',
'',
'YVP',
1,
1);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -