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
Sub
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 te