 --    LONG_TITLE VARCHAR(255) NOT NULL);
 
 LOAD DATA LOCAL INFILE 'D_ICD_PROCEDURES_DATA_TABLE.csv' INTO TABLE D_ICD_PROCEDURES
-   FIELDS TERMINATED BY ',' ESCAPED BY '\\' OPTIONALLY ENCLOSED BY '"' 
+   FIELDS TERMINATED BY ',' ESCAPED BY '\\' OPTIONALLY ENCLOSED BY '"'
    LINES TERMINATED BY '\n'
    IGNORE 1 LINES
    (@ROW_ID,@ICD9_CODE,@SHORT_TITLE,@LONG_TITLE)

--    LOS VARCHAR(255));

LOAD DATA LOCAL INFILE 'TRANSFERS_DATA_TABLE.csv' INTO TABLE TRANSFERS
   FIELDS TERMINATED BY ',' ESCAPED BY '\\' OPTIONALLY ENCLOSED BY '"' 
   LINES TERMINATED BY '\n'
   IGNORE 1 LINES
   (@ROW_ID,@SUBJECT_ID,@HADM_ID,@ICUSTAY_ID,@DBSOURCE,@EVENTTYPE,@PREV_CAREUNIT,@CURR_CAREUNIT,@PREV_WARDID,@CURR_WARDID,@INTIME,@OUTTIME,@LOS)

-- --------------------------------------------------------

  CREATE TABLE DRGCODES
   (	ROW_ID BIGINT,
	SUBJECT_ID INT,
	HADM_ID INT,
	DRG_TYPE VARCHAR(20),
	DRG_CODE VARCHAR(20),
	DESCRIPTION VARCHAR(255),
	DRG_SEVERITY SMALLINT,
	DRG_MORTALITY SMALLINT
   ) ;

