List:General Discussion« Previous MessageNext Message »
From:Octavian Rasnita Date:May 1 2007 8:54am
Subject:Re: show tables
View as plain text  
Ok, thank you all. It was my mistake. I have quoted the SQL command with 
single quotes under Windows.

Octavian

----- Original Message ----- 
From: "Stijn Verholen" <sverholen@stripped>
To: "Octavian Rasnita" <orasnita@stripped>
Cc: <mysql@stripped>
Sent: Tuesday, May 01, 2007 10:57 AM
Subject: Re: show tables


> Octavian Rasnita wrote:
>> Hi,
>>
>> I want to print the list of tables (one on a line) from a database into 
>> an external file.
>> I have tried:
>>
>> mysql -u user -p database -e 'show tables;' > file.txt
>>
>> mysql -u root -p information_schema -e 'select table_name from tables 
>> where table_schema="database_name";' > file.txt
>>
>> 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.
>> The list of tables is big, and it doesn't fit into a screen and that's 
>> why I need to print it into a file.
>>
>> Please tell me how can I do this if it possible.
>>
>> Thank you.
>>
>> Octavian
>>
>>
>
> Hey,
>
> Try:
>
> mysql -u<user> -p<password> -e "SHOW TABLES FROM <database>;" >
> file.txt
>
> Stijn
>
> -- 
>
>
> metastable
> Stijn Verholen
> Camille Huysmanslaan 114, bus 2
> B-2020 ANTWERPEN
> +32 (0)3 707 08 08
> +32 (0)473 47 62 88
> info@stripped
> http://www.metastable.be
>
> BTW-BE 0873.645.643
> bankrek.nr. ING 363-0106543-77
> 

Thread
show tablesOctavian Rasnita1 May
  • Re: show tablesStijn Verholen1 May
    • Re: show tablesMogens Melander1 May
  • Re: show tablesOctavian Rasnita1 May