Projekt: Hesla Jednoty bratrské/2011/load data infile.sql

Z Wikiverzity
Skočit na navigaci Skočit na vyhledávání

Projekt: Hesla Jednoty bratrské/2011/load data infile.sql

TRUNCATE TABLE import;

LOAD DATA LOCAL INFILE "import.csv"
	INTO TABLE import
	FIELDS
		TERMINATED BY ','
		ENCLOSED BY '"'
		ESCAPED BY ''
	LINES	TERMINATED BY '\n'
	IGNORE 1 LINES
	(MonSpruch_Bibeltext, Gedenktage_Ek, Ft1_Bibeltext, Ft1_Angaben, Ft2_Bibeltext, Ft2_Angaben,
	Los_Nummer, Los_Bibeltext, Lt_Bibeltext, Dt_Text, Dt_Quelle, Gedenktage_Ebu,
	Datum, MonSpruch_Stelle, MonSpruch_Quelle, Ft1_Feiertag, Ft1_Stelle, Ft1_Quelle,
	Ft2_Feiertag, Ft2_Stelle, Ft2_Quelle, Los_Vortext, Los_Stelle, Los_Quelle,
	Lt_Vortext, Lt_Stelle, Lt_Quelle, Dt_Gesangbuch, Dt_Autor, Bibellese_1, Bibellese_2);

# SHOW WARNINGS;