blob: bc56c08a1b019beea2950976ee67eef344776800 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
USE busunternehmen;
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/bus.csv" INTO TABLE Bus LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/ort.csv" INTO TABLE Ort LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/wochentag.csv" INTO TABLE Wochentage LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/farbe.csv" INTO TABLE Farbe LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/haltestelle.csv" INTO TABLE Haltestelle LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/liegt_in.csv" INTO TABLE liegt_in LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/route.csv" INTO TABLE Route LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/strecke.csv" INTO TABLE Strecke LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/routenabschnitt.csv" INTO TABLE Routenabschnitt LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/von.csv" INTO TABLE Von LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/nach.csv" INTO TABLE Nach LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/verwendet_als.csv" INTO TABLE verwendet_als LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/beinhaltet.csv" INTO TABLE beinhaltet LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/fahrplan.csv" INTO TABLE Fahrplan LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/fahrt.csv" INTO TABLE Fahrt LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/setzt_ein.csv" INTO TABLE Setzt_ein LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/deckt_ab.csv" INTO TABLE Deckt_ab LINES TERMINATED BY '\n';
LOAD DATA LOCAL INFILE "/home/sven/Studium/Datenbanken/P5/enthaelt.csv" INTO TABLE Enthaelt LINES TERMINATED BY '\n';
|
