I have many similar tables to combine into one, for a report.

Does any one know of a method I could use to compare structural
differences between tables?

Currently I copy the table, truncate the copy, and print it out, and
then examine the differences on paper, but this becomes tedious for
doing more than a couple tables, and is prone to error.

There has to be a better way.

Jim

Jim Britain schreef:
> I have many similar tables to combine into one, for a report.
>
> Does any one know of a method I could use to compare structural
> differences between tables?
>
> Currently I copy the table, truncate the copy, and print it out, and
> then examine the differences on paper, but this becomes tedious for
> doing more than a couple tables, and is prone to error.
>
> There has to be a better way.
>
> Jim
>
>
>

give us, i.e. from two tables you like to compare the output of

SHOW COLUMNS FROM table1;

and maybe even a SELECT * from table1 LIMIT 5;
to know what you think is 'similar'

and give an example on how you want to 'combine' these other than using
a UNION function (http://dev.mysql.com/doc/refman/5.0/en/union.html)


--
Luuk

Jim Britain <nomail2me@suddenlink.net> wrote in
news:bg5004pi3b77hrrvbaiv7bcstrlukpevml@4ax.com:

>
> There has to be a better way.
>

http://schemacrawler.sourceforge.net/

On Sat, 12 Apr 2008 16:21:42 GMT, "Ana C. Dent"
<anacedent@hotmail.com> wrote:

>Jim Britain <nomail2me@suddenlink.net> wrote in
>news:bg5004pi3b77hrrvbaiv7bcstrlukpevml@4ax.com :
>
>>
>> There has to be a better way.
>>
>
>http://schemacrawler.sourceforge.net/

Exactly what I was looking for, in particular the diffs.

Jim Britain <nomail2me@suddenlink.net> wrote:
>
> Does any one know of a method I could use to compare structural
> differences between tables?

<canonical answer>
http://www.google.com/search?q=mysql+diff
</canonical answer>


XL
--
Axel Schwenke, Support Engineer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/

On Sat, 12 Apr 2008 19:48:55 +0200, Axel Schwenke
<axel.schwenke@gmx.de> wrote:

>Jim Britain <nomail2me@suddenlink.net> wrote:
>>
>> Does any one know of a method I could use to compare structural
>> differences between tables?
>
><canonical answer>
>http://www.google.com/search?q=mysql+diff

Why didn't I think of that?? Too deep into the project, I guess.
There's a tradeoff between research and getting a tedious project
done. Boring & tedious leads to research...

Thanks -- I needed that..