cricket-database/import_csv.sql at master · CharithYMendis/cricket-database · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
SELECT M_HOMENUM, M_OPPNUM, M_RESULT, M_TOSSWON, M_BATFIRST, M_GROUNDNUM, M_DATE, M_DAYNIGHT, M_NEUTRAL, STRENGTH
FROM Matches, benchstrength
WHERE NEWID = M_ID
INTO OUTFILE 'C:/WHOLE_MATCHES.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';

SELECT M_HOMENUM, M_OPPNUM, M_RESULT, M_TOSSWON, M_BATFIRST, M_GROUNDNUM, M_DATE, M_DAYNIGHT, M_NEUTRAL, STRENGTH
FROM Matches, benchstrength
WHERE NEWID = M_ID AND M_HOMENUM = 1 AND M_OPPNUM = 2
INTO OUTFILE 'C:/1_2_MATCHES.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';

SELECT M_HOMENUM, M_OPPNUM, M_RESULT, M_TOSSWON, M_BATFIRST, M_GROUNDNUM, M_DATE, M_DAYNIGHT, M_NEUTRAL, STRENGTH
FROM Matches, benchstrength
WHERE NEWID = M_ID AND M_HOMENUM = 2 AND M_OPPNUM = 1
INTO OUTFILE 'C:/2_1_MATCHES.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';