Alfredo Cole <alfredo@stripped> wrote on 08/26/2005 10:07:30 AM:
> I need to compare the structure of two tables (fields, field types,
> lengths, indices, etc.) to determine if they have the same schema, even
> the fields may be in a different order. Is there a command in mysql that
> do this? This will be used to determine if the tables are basically the
> or if they need to be upgraded based on the table structures of a
> Thank you.
> Alfredo J. Cole
> Grupo ACyC
No, there is no built-in command to make this kind of comparison. However
the family of SHOW ... commands (SHOW CREATE TABLE, SHOW COLUMNS, etc.)
will really help you to do this kind of comparison by hand.
Unimin Corporation - Spruce Pine