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
Possibly you need the SELECT ... INTO OUTFILE command
(http://www.mysql.com/doc/en/SELECT.html) which has export options
(explained on http://www.mysql.com/doc/en/LOAD_DATA.html, because the
command is the complement to LOAD DATA INFILE).
|-+-->
| |
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 '\n'
FROM arb_table
WHERE arb_conditions
There are quite a few options available, so I suggest you check th
