Mysql textimport

MySql import:

load data infile '/var/www/termeles.txt'
into table termek
fields terminated by ' ' optionally enclosed by '"'
ignore 1 lines
(@a,@b,@c,@d,@e,@f,@g,@h,@i,@j,@k,@l,@m,@n,@o,@p,@q,@r,@s)
set esemeny=@a,
gyartasi_idopont=@b,
muszak=SUBSTRING_INDEX(@c,"/",-1),
minosegmegorzesi_ido=concat(substr(@c,1,4),'-',substr(@c,5,2),'-',substr(@c,7,2)),
raktar=@d,
termekkod=@e,
gyartott_mennyiseg=replace(@i,',','.');

Másik féle import:
LOAD DATA INFILE '/var/www/adatok.csv'
  INTO TABLE szemelytorzs_inc
  FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n'