Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- mysql_-_load_data_infile [2024-10-25 12:37:04] – [Test: LOAD DATA INFILE] manfred
+++ mysql_-_load_data_infile [2024-10-25 13:26:52] (aktuell) – manfred
@@ Zeile 6: / Zeile 6: @@
 ===== Daten in Datei exportieren =====
-  > echo "SELECT * INTO OUTFILE '/var/lib/mysql-files/data.csv' FIELDS TERMINATED BY ';' FROM testdb.datentabelle" | mysql
+  > echo "SELECT * INTO OUTFILE '/var/lib/mysql-files/data.csv' FIELDS TERMINATED BY ';' FROM dbname.tabname" | mysql
 ==== secure_file_priv ====
-  > echo "SELECT * INTO OUTFILE 'data_1234567.txt' FIELDS TERMINATED BY ';' FROM testdb.datentabelle" | mysql
+  > echo "SELECT * INTO OUTFILE 'data_1234567.txt' FIELDS TERMINATED BY ';' FROM dbname.tabname" | mysql
   ERROR 1290 (HY000) at line 1: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
@@ Zeile 21: / Zeile 21: @@
   +------------------+-----------------------+
-  > echo "SELECT * INTO OUTFILE '/var/lib/mysql-files/data_1234567.txt' FIELDS TERMINATED BY ';' FROM testdb.datentabelle" | mysql
+  > echo "SELECT * INTO OUTFILE '/var/lib/mysql-files/data_1234567.txt' FIELDS TERMINATED BY ';' FROM dbname.tabname" | mysql
   > ls -lha /var/lib/mysql-files/
@@ Zeile 33: / Zeile 33: @@
 eine CSV-Datei importieren, in der die Felder durch ";" getrennt werden und die erste Zeile (beispielsweise der Tabellenkopf) übersprungen wird:
-  > echo "LOAD DATA LOCAL INFILE '/var/lib/mysql-files/data.csv' INTO TABLE testdb.datentabelle FIELDS TERMINATED BY ';' IGNORE 1 LINES;" | mysql
+  > echo "LOAD DATA LOCAL INFILE '/var/lib/mysql-files/data.csv' INTO TABLE dbname.tabname FIELDS TERMINATED BY ';' IGNORE 1 LINES;" | mysql