SELECT * INTO OUTFILE 'data.txt' FIELDS TERMINATED BY ';' FROM preps;

set @n=0 ;SELECT @n := @n+1 as id , adresse domain,toplevel,partei,rubrik,privat, name,vorname,lastsent,valid,blocked,count INTO OUTFILE 'data.txt' FIELDS TERMINATED BY ';'from mail_adressen ;