Created
January 19, 2020 15:26
-
-
Save Baronsindo/8b3c969493009459d76cb8f051b10c34 to your computer and use it in GitHub Desktop.
Medical specialties list in SQL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE specialties( | |
id int not null primary key, | |
name varchar(50) | |
); | |
insert into specialties (id,name) values | |
("1","Accident and emergency medicine"), | |
("2","Allergology"), | |
("3","Anaesthetics"), | |
("4","Biological hematology"), | |
("5","Cardiology"), | |
("6","Child psychiatry"), | |
("7","Clinical biology"), | |
("8","Clinical chemistry"), | |
("9","Clinical neurophysiology"), | |
("10","Clinical radiology"), | |
("11","Dental, oral and maxillo-facial surgery"), | |
("12","Dermato-venerology"), | |
("13","Dermatology"), | |
("14","Endocrinology"), | |
("15","Gastro-enterologic surgery"), | |
("16","Gastroenterology"), | |
("17","General hematology"), | |
("18","General Practice"), | |
("19","General surgery"), | |
("20","Geriatrics"), | |
("21","Immunology"), | |
("22","Infectious diseases"), | |
("23","Internal medicine"), | |
("24","Laboratory medicine"), | |
("25","Maxillo-facial surgery"), | |
("26","Microbiology"), | |
("27","Nephrology"), | |
("28","Neuro-psychiatry"), | |
("29","Neurology"), | |
("30","Neurosurgery"), | |
("31","Nuclear medicine"), | |
("32","Obstetrics and gynecology"), | |
("33","Occupational medicine"), | |
("34","Ophthalmology"), | |
("35","Orthopaedics"), | |
("36","Otorhinolaryngology"), | |
("37","Paediatric surgery"), | |
("38","Paediatrics"), | |
("39","Pathology"), | |
("40","Pharmacology"), | |
("41","Physical medicine and rehabilitation"), | |
("42","Plastic surgery"), | |
("43","Podiatric Medicine"), | |
("44","Podiatric Surgery"), | |
("45","Psychiatry"), | |
("46","Public health and Preventive Medicine"), | |
("47","Radiology"), | |
("48","Radiotherapy"), | |
("49","Respiratory medicine"), | |
("50","Rheumatology"), | |
("51","Stomatology"), | |
("52","Thoracic surgery"), | |
("53","Tropical medicine"), | |
("54","Urology"), | |
("55","Vascular surgery"), | |
("56","Venereology"); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment