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]