abTivu3U

1CREATE TEMPORARY TABLE IF NOT EXISTS tempRoom ( 
2 `course`   VARCHAR(10) NOT NULL, 
3 `room`     VARCHAR(10) NOT NULL 
4 );
5 TRUNCATE TABLE room_course; 
6 TRUNCATE TABLE tempRoom; 
7 LOAD DATA LOCAL INFILE ? INTO TABLE tempRoom 
8 FIELDS TERMINATED BY ',' 
9 ENCLOSED BY '\"' 
10 LINES TERMINATED BY '\n' 
11 IGNORE 1 LINES; 
12 INSERT INTO room_course (`year`, `semester`,`course`, `room`) 
13 SELECT 
14 2016, 
15 1, 
16 temp.course, 
17 temp.room 
18 FROM tempRoom temp;
19 DROP TEMPORARY TABLE IF EXISTS tempRoom; ";