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'
FIELD
gt;
Sent: Tuesday, October 21, 2003 1:40 PM
Subject: Re: export to textfile
Helloand ty for the fast answers, but
Am Dienstag, 21. Oktober 2003 13:10 schrieben Sie:
> Hi Bernd
> If you are just interested in dumping the data in CSV (or whatever) format
> you can do it like so
Helloand ty for the fast answers, but
Am Dienstag, 21. Oktober 2003 13:10 schrieben Sie:
> Hi Bernd
> If you are just interested in dumping the data in CSV (or whatever) format
> you can do it like so:
> SELECT *
> INTO OUTFILE 'arb_file.csv' FIELDS TERMINATED BY ',' LINE TERMINATED BY
> '
Bernd Tannenbaum <[EMAIL PROTECTED]> wrote:
>
> Have only a small problem with my mysql and hope that i can get a lil hint
> from ya how to go on.
> Currently i`m importing Log-files in the mysql-database with a cronjob
> (bashscript in Linux). After some processing in the db itself i try now to
EMAIL PROTECTED]
|
| cc:
|
| Subject: exp
;Bernd Tannenbaum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 21, 2003 12:42 PM
Subject: export to textfile
Hello all,
Have only a small problem with my mysql and hope that i can get a lil hint
from ya how to go on.
Currently i`m importing Log-files in
Hello all,
Have only a small problem with my mysql and hope that i can get a lil hint
from ya how to go on.
Currently i`m importing Log-files in the mysql-database with a cronjob
(bashscript in Linux). After some processing in the db itself i try now to
export the results into a textfile.
But i
