From 33613a85afc4b1481367fbe92a17ee59c240250b Mon Sep 17 00:00:00 2001
From: Sven Eisenhauer <sven@sven-eisenhauer.net>
Date: Fri, 10 Nov 2023 15:11:48 +0100
Subject: add new repo

---
 Bachelor/Datenbanken/P5/data_p5.sql | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 Bachelor/Datenbanken/P5/data_p5.sql

(limited to 'Bachelor/Datenbanken/P5/data_p5.sql')

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
-- 
cgit v1.3

