On Tue, May 1, 2007 09:57, Stijn Verholen wrote:
> Octavian Rasnita wrote:
>>
>> mysql -u user -p database -e 'show tables;' > file.txt

That one works for me, with a litle change. -s (kill's columnnames a.o.).

[EMAIL PROTECTED]:~# mysql -s -u rppt test -e 'show tables;' > file.txt
[EMAIL PROTECTED]:~# cat file.txt
abc
store
t
tablea
trans

Hmmm, there is no such user "-u rppt" but it works anyway ???
Maybe because it's the test db.

>> But the result was the help file displayed by MySQL when a command is
>> not correct. The SQL queries I gave are correct, because they work
>> when I give them at the mysql prompt.

What error message do you get ?

-- 
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.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to