Hi,
If you can't read that output, try the
select * from mytable INTO OUTFILE "absolutepath/myfile.txt" FIELDS
TERMINATED BY "," LINES TERMINATED BY "\r\n"
statement.
I do somthing with this :-)
Adib.
chad kellerman wrote:
> Takacs,
>
> I think you can use
>
> mysql --execute=<select * from whatever> databasename
>
> you should be able to execute mysql command thru bash that way.
>
> chad
>
>
> On Tue, 19 Mar 2002 10:20:08 +0100
> "Takacs Istvan" <[EMAIL PROTECTED]> wrote:
>
>
>>Hi
>>
>>Is that possible to query the database from a bash
>>script?
>>I need some informations from a table, and it looks
>>the easiest way.
>>How can I connect, use a database, and query
>>a table?
>>
>>Thanks in advance!
>>
>>Regards;
>>
>>
Istvan
>>
>>---------------------------------------------------------------------
>>Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>>To request this thread, e-mail <[EMAIL PROTECTED]>
>>To unsubscribe, e-mail
<[EMAIL PROTECTED]>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
--
WIGE DATA GmbH
Wiesenring 11, D-04159 Leipzig, Germany
Adib Taraben
Electronic Engineer
PHONE
+49 (0)341 - 46 21 100
FAX +49 (0)341 - 46 21 400
E-MAIL
[EMAIL PROTECTED]
INTERNET www.wige-data.de
A company of WIGE MEDIA AG
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
