List:General Discussion« Previous MessageNext Message »
From:Winanjaya Date:April 11 2005 9:53am
Subject:RE: Auto SQL
View as plain text  
What tool you're talking now? .. PHPMyAdmin? .. I am using MySQL
Administrator .. and I didnot find such feature .. any suggestion?

thanks a lot in advance
Regards
Winanjaya


-----Original Message-----
From: Jigal van Hemert [mailto:jigal@stripped]
Sent: Monday, April 11, 2005 4:36 PM
To: mysql@stripped
Subject: Re: Auto SQL


From: "Winanjaya"
> 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

I think many MySQL management tools can help you do this.
phpMyAdmin (http://www.phpmyadmin.net/), our 'beloved' :-) web based tool is
one of them.

If you select a database you'll see an overview of all the tables in the
database with some statistics. Select the tab 'Export' and you can set all
the details of the export you want to make.

E.g. Select all tables, SQL export, Structure, no data, download resulting
statements as file, etc. and you'll end up with a nice list of CREATE TABLE
statements for all the selected tables.

Regards, Jigal.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1


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