row -- tho I think there is
an option 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 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 wrot
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: