set FOREIGN_KEY_CHECKS=0;
load data infile 'D:/CSV1M/ObjectOfClass1.csv' into table ObjectOfClass
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/OOC1.csv' into table OOC
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/ObjectOfClass2.csv' into table ObjectOfClass
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/OOC2.csv' into table OOC
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/ObjectOfClass3.csv' into table ObjectOfClass
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/OOC3.csv' into table OOC
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/ObjectOfClass4.csv' into table ObjectOfClass
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/OOC4.csv' into table OOC
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/ObjectOfClass5.csv' into table ObjectOfClass
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/OOC5.csv' into table OOC
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/ObjectOfClass6.csv' into table ObjectOfClass
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/OOC6.csv' into table OOC
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/ObjectOfClass7.csv' into table ObjectOfClass
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/OOC7.csv' into table OOC
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/ObjectOfClass8.csv' into table ObjectOfClass
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/OOC8.csv' into table OOC
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/ObjectOfClass9.csv' into table ObjectOfClass
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/OOC9.csv' into table OOC
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/ObjectOfClass10.csv' into table ObjectOfClass
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/OOC10.csv' into table OOC
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A1.csv' into table A1
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B1.csv' into table B1
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C1.csv' into table C1
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D1.csv' into table D1
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E1.csv' into table E1
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A2.csv' into table A2
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B2.csv' into table B2
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C2.csv' into table C2
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D2.csv' into table D2
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E2.csv' into table E2
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A3.csv' into table A3
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B3.csv' into table B3
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C3.csv' into table C3
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D3.csv' into table D3
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E3.csv' into table E3
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A4.csv' into table A4
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B4.csv' into table B4
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C4.csv' into table C4
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D4.csv' into table D4
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E4.csv' into table E4
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A5.csv' into table A5
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B5.csv' into table B5
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C5.csv' into table C5
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D5.csv' into table D5
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E5.csv' into table E5
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A6.csv' into table A6
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B6.csv' into table B6
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C6.csv' into table C6
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D6.csv' into table D6
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E6.csv' into table E6
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A7.csv' into table A7
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B7.csv' into table B7
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C7.csv' into table C7
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D7.csv' into table D7
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E7.csv' into table E7
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A8.csv' into table A8
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B8.csv' into table B8
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C8.csv' into table C8
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D8.csv' into table D8
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E8.csv' into table E8
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A9.csv' into table A9
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B9.csv' into table B9
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C9.csv' into table C9
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D9.csv' into table D9
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E9.csv' into table E9
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A10.csv' into table A10
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B10.csv' into table B10
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C10.csv' into table C10
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D10.csv' into table D10
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E10.csv' into table E10
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A1_A2.csv' into table `a1#a2s_a2`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B1_B2.csv' into table `b1#b2s_b2`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C1_C2.csv' into table `c1#c2s_c2`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D1_D2.csv' into table `d1#d2s_d2`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E1_E2.csv' into table `e1#e2s_e2`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A2_A3.csv' into table `a2#a3s_a3`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B2_B3.csv' into table `b2#b3s_b3`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C2_C3.csv' into table `c2#c3s_c3`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D2_D3.csv' into table `d2#d3s_d3`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E2_E3.csv' into table `e2#e3s_e3`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A3_A4.csv' into table `a3#a4s_a4`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B3_B4.csv' into table `b3#b4s_b4`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C3_C4.csv' into table `c3#c4s_c4`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D3_D4.csv' into table `d3#d4s_d4`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E3_E4.csv' into table `e3#e4s_e4`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A4_A5.csv' into table `a4#a5s_a5`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B4_B5.csv' into table `b4#b5s_b5`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C4_C5.csv' into table `c4#c5s_c5`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D4_D5.csv' into table `d4#d5s_d5`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E4_E5.csv' into table `e4#e5s_e5`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A5_A6.csv' into table `a5#a6s_a6`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B5_B6.csv' into table `b5#b6s_b6`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C5_C6.csv' into table `c5#c6s_c6`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D5_D6.csv' into table `d5#d6s_d6`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E5_E6.csv' into table `e5#e6s_e6`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A6_A7.csv' into table `a6#a7s_a7`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B6_B7.csv' into table `b6#b7s_b7`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C6_C7.csv' into table `c6#c7s_c7`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D6_D7.csv' into table `d6#d7s_d7`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E6_E7.csv' into table `e6#e7s_e7`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A7_A8.csv' into table `a7#a8s_a8`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B7_B8.csv' into table `b7#b8s_b8`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C7_C8.csv' into table `c7#c8s_c8`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D7_D8.csv' into table `d7#d8s_d8`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E7_E8.csv' into table `e7#e8s_e8`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A8_A9.csv' into table `a8#a9s_a9`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B8_B9.csv' into table `b8#b9s_b9`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C8_C9.csv' into table `c8#c9s_c9`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D8_D9.csv' into table `d8#d9s_d9`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E8_E9.csv' into table `e8#e9s_e9`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/A9_A10.csv' into table `a9#a10s_a10`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/B9_B10.csv' into table `b9#b10s_b10`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/C9_C10.csv' into table `c9#c10s_c10`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/D9_D10.csv' into table `d9#d10s_d10`
fields terminated by ','
lines terminated by ';\n';
load data infile 'D:/CSV1M/E9_E10.csv' into table `e9#e10s_e10`
fields terminated by ','
lines terminated by ';\n';
set FOREIGN_KEY_CHECKS=1;
