diff options
| author | Sven Eisenhauer <sven@sven-eisenhauer.net> | 2023-11-10 15:11:48 +0100 |
|---|---|---|
| committer | Sven Eisenhauer <sven@sven-eisenhauer.net> | 2023-11-10 15:11:48 +0100 |
| commit | 33613a85afc4b1481367fbe92a17ee59c240250b (patch) | |
| tree | 670b842326116b376b505ec2263878912fca97e2 /Bachelor/Datenbanken/P5/data_p5.sql | |
| download | Studium-master.tar.gz Studium-master.tar.bz2 | |
Diffstat (limited to 'Bachelor/Datenbanken/P5/data_p5.sql')
| -rw-r--r-- | Bachelor/Datenbanken/P5/data_p5.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/Bachelor/Datenbanken/P5/data_p5.sql b/Bachelor/Datenbanken/P5/data_p5.sql new file mode 100644 index 0000000..bc56c08 --- /dev/null +++ b/Bachelor/Datenbanken/P5/data_p5.sql @@ -0,0 +1,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';
\ No newline at end of file |