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. --------------------------------------------------------------------- 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