wb2VBvMP

1$db_query = "DROP TABLE IF EXISTS ".$station.$year.$pollutant;
2  $db_conn->query($db_query);
3
4  $db_query = "CREATE TABLE ".$station.$year.$pollutant."
5      (date DATE NOT NULL,h1 FLOAT NOT NULL,h2 FLOAT NOT NULL,h3 FLOAT NOT NULL,
6      h4 FLOAT NOT NULL,h5 FLOAT NOT NULL,h6 FLOAT NOT NULL,h7 FLOAT NOT NULL,
7      h8 FLOAT NOT NULL,h9 FLOAT NOT NULL,h10 FLOAT NOT NULL,h11 FLOAT NOT NULL,
8      h12 FLOAT NOT NULL,h13 FLOAT NOT NULL,h14 FLOAT NOT NULL,h15 FLOAT NOT NULL,
9      h16 FLOAT NOT NULL,h17 FLOAT NOT NULL,h18 FLOAT NOT NULL,h19 FLOAT NOT NULL,
10      h20 FLOAT NOT NULL,h21 FLOAT NOT NULL,h22 FLOAT NOT NULL,h23 FLOAT NOT NULL,
11      h24 FLOAT NOT NULL) ENGINE = CSV;";
12  $db_conn->query($db_query);
13
14  $db_query = "LOAD DATA LOCAL INFILE '".$file."' INTO TABLE ".$station.$year.$pollutant."
15      FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\r\n'
16      (@var,h1,h2,h3,h4,h5,h6,h7,h8,h9,h10,h11,h12,h13,h14,h15,h16,h17,h18,h19,h20,h21,h22,h23,h24)
17      SET date = STR_TO_DATE(@var,'%d-%m-%Y')";
18  $db_conn->query($db_query);