List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 6 2002 8:37pm
Subject:RE: Merge tables, was [two table's columns into one columns w/o
INSERT ... SELECT?]
View as plain text  
At 15:29 -0500 5/6/02, Jay Blanchard wrote:
>I have these two tables;
>mysql> describe tblClass11;
>+--------------+---------------+------+-----+---------+----------------+
>| Field        | Type          | Null | Key | Default | Extra          |
>+--------------+---------------+------+-----+---------+----------------+
>| ID           | int(11)       |      | PRI | NULL    | auto_increment |
>| RecordID     | varchar(6)    | YES  |     | NULL    |                |
>| RecordDate   | varchar(10)   | YES  |     | NULL    |                |
>| CIC          | varchar(4)    | YES  |     | NULL    |                |
>| Minutes      | decimal(12,2) | YES  |     | NULL    |                |
>| FileName     | varchar(32)   | YES  |     | NULL    |                |
>| RecordNumber | int(11)       | YES  |     | NULL    |                |
>| WholeRecord  | text          | YES  |     | NULL    |                |
>| ReceivedDate | varchar(10)   | YES  |     | NULL    |                |
>+--------------+---------------+------+-----+---------+----------------+
>9 rows in set (0.00 sec)
>
>mysql> describe tblClassOthers;
>+--------------+---------------+------+-----+---------+----------------+
>| Field        | Type          | Null | Key | Default | Extra          |
>+--------------+---------------+------+-----+---------+----------------+
>| ID           | int(11)       |      | PRI | NULL    | auto_increment |
>| RecordID     | varchar(6)    | YES  |     | NULL    |                |
>| RecordDate   | varchar(10)   | YES  |     | NULL    |                |
>| CIC          | varchar(4)    | YES  |     | NULL    |                |
>| Minutes      | decimal(12,2) | YES  |     | NULL    |                |
>| FileName     | varchar(32)   | YES  |     | NULL    |                |
>| RecordNumber | int(11)       | YES  |     | NULL    |                |
>| WholeRecord  | text          | YES  |     | NULL    |                |
>| ReceivedDate | varchar(10)   | YES  |     | NULL    |                |
>+--------------+---------------+------+-----+---------+----------------+
>9 rows in set (0.00 sec)
>
>I attempt to MERGE;
>mysql> CREATE TABLE tblCross1 (ID INT NOT NULL,
>     -> RecordID VARCHAR(6),
>     -> RecordDate VARCHAR(10),
>     -> Minutes DECIMAL(12,2),
>     -> KEY(ID))
>     -> TYPE=MERGE
>     -> UNION=(tblClass11, tblClassOthers);
>Query OK, 0 rows affected (0.01 sec)
>
>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?
>
>Thanks!
>Jay

Drop the MERGE table, then try creating it with all the columns
in the original tables.
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