Hi,
I'm diffing two versions of a schema produced using mysqldump and would
like to know if there's a way to make mysqldump sort entries inside
CREATE statements (say alphabetically or in some other way)? Currently
some of the column declarations are juxtaposed between the versions and
thus
One way you could solve this is to conform the column orders between
the two versions.
For example, if one table, t6, has columns id, name, and address and
the same table in the second database is id, address, name, you could
just ALTER the second database t6 table to be id, name, address:
Thanks, Douglas!
That seems OK, but I'd prefer to avoid altering the schemas in any way.
In particular altering order of constraints seems error-prone, given
that one is essentially re-defining these, not simply rearranging the
order. Am I asking for impossible? ;-
-nikita
Douglas Sims
to make output less verbose.
-Original Message-
From: Nikita Tovstoles [mailto:[EMAIL PROTECTED]
Sent: Friday, September 08, 2006 2:00 PM
To: mysql@lists.mysql.com
Subject: Re: make mysqldump to sort columns alphabetically
Thanks, Douglas!
That seems OK, but I'd prefer
