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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
