From: Mogens Melander
Date: May 2 2007 6:55am
Subject: Re: batch mode
List-Archive: http://lists.mysql.com/mysql/206496
Message-Id: <3100.90.184.17.152.1178088929.squirrel@mail.fumlersoft.dk>
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit


On Tue, May 1, 2007 22:15, Brown, Charles wrote:
>
> Because I am running on batch mode therefore I'm trying to direct my
> session output to a file -- meaning stdout. But I'm having a problem.
> For instance this input: "use test_db" gave me no output but this input
> "show tables" gave me an output.
>
> What is missing, what's the trick. Help me Y'all.

You could try something like:

mysql -u xxx -pyyy -e 'select * from dbname;'

mysql -u xxx -pyyy -e 'select * from dbname.tblname;'

-- 
Later

Mogens Melander
+45 40 85 71 38
+66 870 133 224



-- 
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.