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
> export the results into a textfile.
> But i must be blind reading the mysql documentation cause i cannot find a
> mysqlexport. Hmm, Mysqldump can be used to backup the db, thats not what i
> need. Then i found "mysql -e" and it rly writes the chosen fields to a
> textfile but i dont know how to get options to that (like
> fileds-terminated-by=';' or stuff like that).
>
> So did i miss something?
> Is there a better way to go than "mysql -e"?
> If not, where can i find a good explanation of the possible options of this,
> every hint welcome.
>
Take a look at SELECT .. INTO OUTFILE:
http://www.mysql.com/doc/en/SELECT.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
