From 33613a85afc4b1481367fbe92a17ee59c240250b Mon Sep 17 00:00:00 2001 From: Sven Eisenhauer 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.2.3