RE: MERGE Table Question

2005-06-10 Thread emierzwa
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

Re: MERGE Table Question

2005-06-10 Thread mos
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