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.
