List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 6 2002 8:55pm
Subject:RE: Merge tables, was [two table's columns into one columns w/o
INSERT ... SELECT?]
View as plain text  
At 15:44 -0500 5/6/02, Jay Blanchard wrote:
>[snip]
>>Then I attempt to query;mysql> select count(*) from tblCross1;
>>ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143)
>>perror 143
>>143 = Conflicting table definition between MERGE and mapped table
>>
>>Can anyone help with this?
>
>Drop the MERGE table, then try creating it with all the columns
>in the original tables.
>[/snip]
>
>OK, that work with two of the tables, I have to merge 3. Is that possible?

Yes.

>
>Do the INDEXES have to exist on the same columns in each table? How
>identical do the tables have to be?

Identical.  Column names, types, order within tables, and indexes.

>
>Thanks!
>
>Jay
>
>P.S. Paul, couldn't help but notice your last name, where are you from?

Huh?  Wisconsin.
Thread
two table's columns into one columns w/o INSERT ... SELECT?Jay Blanchard6 May
  • Re: two table's columns into one columns w/o INSERT ... SELECT?Paul DuBois6 May
    • RE: two table's columns into one columns w/o INSERT ... SELECT?Jay Blanchard6 May
      • RE: two table's columns into one columns w/o INSERT ... SELECT?Keith C. Ivey6 May
        • RE: two table's columns into one columns w/o INSERT ... SELECT?Jay Blanchard6 May
          • RE: Merge tables, was [two table's columns into one columns w/o INSERT ... SELECT?]Jay Blanchard6 May
            • RE: Merge tables, was [two table's columns into one columns w/oINSERT ... SELECT?]Paul DuBois6 May
              • RE: Merge tables, was [two table's columns into one columns w/o INSERT ... SELECT?]Jay Blanchard6 May
                • RE: Merge tables, was [two table's columns into one columns w/oINSERT ... SELECT?]Paul DuBois6 May
  • Question & Observation!problem9 May