On Wed, May 2, 2007 08:55, Mogens Melander wrote:
> 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;'
Argh, that should have been:
mysql -s -u xxx -pyyy -e 'show tables from dbname;'
> mysql -u xxx -pyyy -e 'select * from dbname.tblname;'
mysql -s -u xxx -pyyy -e 'select * from dbname.tblname;'
> 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.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
+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.