List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:September 19 1999 10:07am
Subject:Re: Command line queries?
View as plain text  
>>>>> "Tõnu" == Tõnu Samuel <tonu@stripped> writes:

Tõnu> Karen wrote:
>> Does anyone know the right format to do a query from
>> the command line? Like mysql database < 'select * from
>> test' ?

Tõnu> I see this question is answered already but additionally:

Tõnu> You are right in using unix pipes concept but did a little error. You can
do
Tõnu> it properly in other this too:

Tõnu> echo "select * from test" | mysql database

Another option is using:

mysql -e "select * from test" test

Regards,
Monty
Thread
Command line queries?Karen17 Sep
  • Re: Command line queries?Bob Kline17 Sep
  • Re: Command line queries?tonu18 Sep
    • Re: Command line queries?Michael Widenius19 Sep