List:General Discussion« Previous MessageNext Message »
From:Wolfram Kraus Date:April 11 2005 12:42pm
Subject: Re: Auto SQL
View as plain text  
Winanjaya wrote:
> Dear MySQL Experts,
> 
> I am using MySQL 4.1, I have a database with more than 100 tables inside, is
> there any 3rd party tools that can help me to create a SQL statement of
> "CREATE TABLE blah blah blah" for each table in my DB . please advise
> 
> 
> Regards
> Winanjaya
> 
> 

mysqldump -d --add-drop-table=0 -n -u USERNAME -p DATABASE

Replace USERNAME & DATABASE with your actual values.
For more options see: mysqldump --help

HTH,
Wolfram

Thread
Auto SQLWinanjaya11 Apr
  • Re: Auto SQLJigal van Hemert11 Apr
    • RE: Auto SQLWinanjaya11 Apr
  • Re: Auto SQLMartijn Tonies11 Apr
  • Re: Auto SQLJohn Doe11 Apr
  • Re: Auto SQLWolfram Kraus11 Apr