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?

1 comment
Comment actions Permalink

Please specify path like

C:/xampp/AVD_ZI_KV72_202108_01_20211005_094200_FADMP.csv

that should work.

0

Please sign in to leave a comment.