If you have MySQL5 you can show table structure via the
'information_schema' pseudo-database. This has the advantage of
dumping column data for all tables in one output table. In addition,
you can select/sort the metadata using standard SQL:
[EMAIL PROTECTED]> show tables from information_schema;
That works. Thanks.
Tony
-Original Message-
From: Mogens Melander <[EMAIL PROTECTED]>
To: Olaf Stein <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]; MySql
Sent: Mon, 23 Jul 2007 12:29 pm
Subject: Re: Seeing Table Structure
Try this:
# mysqldump -d DBNAME > tables.sql
--n
Yes, please, email it to me.
Tony
-Original Message-
From: Olaf Stein <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]; MySql
Sent: Mon, 23 Jul 2007 12:22 pm
Subject: Re: Seeing Table Structure
I don't know of any way of doing this for all tables.
wrote a python script tha
Try this:
# mysqldump -d DBNAME > tables.sql
--no-data, -d
Do not write any row information for the table.
This is very useful if you want to dump only
the CREATE TABLE statement for the table.
On Mon, July 23, 2007 18:22, Olaf Stein wrote:
> I don't know of any way of doing this for all
I don't know of any way of doing this for all tables.
I wrote a python script that creates a html file with information about
tables (engine, fields,keys,indices)
If you are interested in it I can email it
Olaf
On 7/23/07 11:34 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Hi;
> I need t
Hi;
I need to see the table structure of all the tables of a database I have. I
could also just dump all the data from all the tables in the database and copy
the database, thus grabbing the table structures. I canĀ“t find in the
documentation how to do either of those. Please advise.
TIA,
Tony
_