MySQL Forums
Forum List  »  German

Advanced Search
New Topic

Re: 2.Versuch: Import-Probleme mit LOAD DATA Infile durch NULL - Werte
Posted by: Wolfgang Moriske
Date: October 20, 2015 06:32AM

Etwas viel Schreibarbeit ... aber geht:

LOAD DATA LOCAL INFILE 'C:/import/felder.csv' INTO TABLE Import_felder
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(@feld1, @feld2, @feld3, @feld4, @feld5)
SET
feld1 = NULLIF(@feld1,''), feld2 = NULLIF(@feld2,''), feld3 = NULLIF(@feld3,''), feld4 = NULLIF(@feld4,'') usw. usw.

Habe ich hier gefunden: http://stackoverflow.com/questions/2675323/mysql-load-null-values-from-csv-data

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Import-Probleme mit LOAD DATA Infile durch NULL - Werte
1582
Irene Eisen
October 14, 2015 03:17AM
2.Versuch: Import-Probleme mit LOAD DATA Infile durch NULL - Werte
808
Irene Eisen
October 15, 2015 02:08AM
Re: 2.Versuch: Import-Probleme mit LOAD DATA Infile durch NULL - Werte
826
Wolfgang Moriske
October 20, 2015 06:32AM
Re: 2.Versuch: Import-Probleme mit LOAD DATA Infile durch NULL - Werte
579
Irene Eisen
October 21, 2015 04:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.