| 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 textfile | Bernd Tannenbaum | 21 Oct |
| • Re: export to textfile | Rory McKinley | 21 Oct |
| • Re: export to textfile | Bernd Tannenbaum | 21 Oct |
| • Re: export to textfile | Victoria Reznichenko | 21 Oct |
| • Re: export to textfile | Rory McKinley | 21 Oct |
| • Re: export to textfile -solved :) | Bernd Tannenbaum | 21 Oct |
| • Moving to Linux and NetApps | Barry Cornelius | 21 Oct |
| • Re: export to textfile | Alec.Cawley | 21 Oct |
