-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathmysql_load.sql
More file actions
23 lines (22 loc) · 1.91 KB
/
Copy pathmysql_load.sql
File metadata and controls
23 lines (22 loc) · 1.91 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
load data local infile '1987_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '1988_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '1989_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '1990_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '1991_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '1992_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '1993_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '1994_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '1995_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '1996_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '1997_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '1998_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '1999_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '2000_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '2001_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '2002_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '2003_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '2004_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '2005_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '2006_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '2007_na_to_null.csv' into table ontime fields terminated by ",";
load data local infile '2008_na_to_null.csv' into table ontime fields terminated by ",";