If you're concerned about subtle data type differences you can also run one "show create table myMergeTable" statement for each source table and diff them.
Ed -----Original Message----- From: mos [mailto:[EMAIL PROTECTED] Sent: Friday, June 10, 2005 8:35 AM To: mySQL list Subject: Re: MERGE Table Question At 09:00 AM 6/10/2005, you wrote: >Hello everyone, > We're going to be using the "MERGE TABLE" option of Mysql when we > build our Data Warehouse. Basically (for you Oracle folks), we're going > to mimic PARTITIONS. My question is this: Other than dumping syntax > through a utility and comparing text, is there any way I can read the > structure directly through the *.FRM or *.MYD files to make certain that > ALL tables match exactly so the MERGE will work? > >Regards, >George George, You could try things like: show tables like "myMergeTable%" to get a list of tables making up the merge. (Assuming the name of the merge tables all start with the similar name) Then with the results of that query execute for each table name returned: show columns from tablex and show index from tablex You could then compare each tablex definition with each other, probably using a program or even SQL if that is the route you wanted to take. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
