List:General Discussion« Previous MessageNext Message »
From:Bernd Tannenbaum Date:October 21 2003 12:19pm
Subject:Re: export to textfile -solved :)
View as plain text  
Hi and thx to all who answered :)

Okay, finally found my mistake with ur help.
One can add the needed options within the "select" statement, not within the 
"mysql -e" statement as i tried.

Working solution is now:
./mysql --skip-column-names -e "select ek_satzart,[...] into outfile 'File' 
FIELDS TERMINATED BY ';' from table" dbname --password=xxxx

Thx all for help,
Bernd





-- 

One OS to rule them all, one OS to find them.
One OS to bring them all, and in the darkness bind them
In the land of Redmond, where the shadows lie.
Thread
export to textfileBernd Tannenbaum21 Oct
  • Re: export to textfileRory McKinley21 Oct
    • Re: export to textfileBernd Tannenbaum21 Oct
  • Re: export to textfileVictoria Reznichenko21 Oct
  • Re: export to textfileRory McKinley21 Oct
    • Re: export to textfile -solved :)Bernd Tannenbaum21 Oct
      • Moving to Linux and NetAppsBarry Cornelius21 Oct
Re: export to textfileAlec.Cawley21 Oct