MariaDb Load Data Infile
Answered
Hello!
Since many years we use the "load dat infile" command for importing large files into the MariaDB- database.
In another Application named AquaDataStudio, the follwing command works fine, but when I try to use it on DataGrip it returns an error.
set @lid = 202108;
load data local infile 'C:\\xampp\\AVD_ZI_KV72_202108_01_20211005_094200_FADMP.csv' replace into table import_avd_fall_test fields terminated by ';' lines terminated by '\n' ignore 1 lines
(zid,kvbsnr,kv,fachgruppe,ik1,ik2,vknr,versstatus,dmpstatus,person_gr,arzik,rpnr,rznr,vdatum,adatum,pzn,menge,vk,bvg,statusvo,spr,import,noctu,
unfall,zuz,gebbefr,autidem,plausi_zi,belegnr_zi,zwangsrabatte_zi,netto1_zi,zuzahlung_zi,netto2_zi,netto3_zi,rabatte_zi,
sum_zuab,zdr02,zdr04
)
set ldat = now(), lid = @lid;
load data local infile 'C:\\xampp\\AVD_ZI_KV72_202108_01_20211005_094200_FADMP.csv' replace into table import_avd_fall_test fields terminated by ';' lines terminated by '\n' ignore 1 lines
(zid,kvbsnr,kv,fachgruppe,ik1,ik2,vknr,versstatus,dmpstatus,person_gr,arzik,rpnr,rznr,vdatum,adatum,pzn,menge,vk,bvg,statusvo,spr,import,noctu,
unfall,zuz,gebbefr,autidem,plausi_zi,belegnr_zi,zwangsrabatte_zi,netto1_zi,zuzahlung_zi,netto2_zi,netto3_zi,rabatte_zi,
sum_zuab,zdr02,zdr04
)
set ldat = now(), lid = @lid;
What is wrong with that?
Please sign in to leave a comment.
Please specify path like
C:/xampp/AVD_ZI_KV72_202108_01_20211005_094200_FADMP.csv
that should work.